- An error has occurred, which probably means the feed is down. Try again later.
Microsoft Certified: Power Platform Solution Architect Expert – Renew
Got 52%, didn’t pass.
Propose a solution as a Solution Architect for Microsoft Power Platform and Dynamics 365(100% correct)
Solution Architect series: Implement integrations with Power Platform(100% correct)
Solution architect series: Model data for Power Platform solutions(0% correct)
A company leases measuring equipment for customers in the chemical field.
An order can include multiple pieces of equipment and additional items, such as specialized tools and installation services. The specialized tools require information such as tool number and date created. The installation services require information such as skills required and estimated installation time.
You are developing the data model for a Microsoft Power Platform solution to replace the existing systems of the company.
Which set of tables should you recommend?Select only one answer.
Accounts, Equipment, Additional items
Accounts, Equipment, Tools, and Services (Bard, Co-pilot) – My Selection (Maybe incorrect)
Accounts, Tools, and Services
Customers, Products, and Services
You are creating a model-driven app that uses standard tables for customer records.
The company uses a Microsoft SQL Server-based on-premises system for its general ledger, accounts payable, and accounts receivable functions.
The app must be able to view and perform calculations based on the discount agreements that the company has with its customers.
What should you recommend?Select only one answer.
Use a SQL gateway with virtual tables.(Bard, POP) My Selection – Chances this is correct – (Maybe incorrect)
Use dual-write to map to the tables.(Copilot)
Use a REST API with a custom connector.
Implement Dynamics 365 Finance.
You are the Microsoft Power Platform system administrator.
You need to deploy an additional Dynamics 365 customer engagement application.
What should you do?Select only one answer.
In the Microsoft Power Platform admin center, navigate to Resources, and then select Dynamics 365 apps.(Copilot, Bard) – I selected – – Chances this is correct
In the Microsoft 365 admin center, navigate to Billing, and then select Your products.
In the Microsoft Power Platform admin center, navigate to Resources, and then select Power Apps.
In the Microsoft Power Platform admin center, open the environment, and then select Settings.
You are designing a Microsoft Power Platform solution for a company.
The company needs many different requirements developed and released over time.
You need to ensure that you meet the initial release requirements by using the business objectives.
Which process should you use?Select only one answer.
Epic
Fork
Minimum viable product(Bard, Copilot, POP) – I selected
User acceptance testing
A tax accounting company needs to implement new budget rules. The company has an automatic process in place to transmit tax information to the government.
Which rule is a functional requirement?Select only one answer.
Medical expenses have a new deadline.
Tax filing supports new formats.(Bard, Copilot, POP) – I selected
Grant amounts are exempt.
Medical expenses have new criteria.
A development team at a company is creating a set of integrated features. Another team is creating a separate set of integrated features. The company follows Microsoft best practice for Application Lifecycle Management (ALM).
The user acceptance testing (UAT) team needs a separate environment to test development work from both teams before moving features into production.
How many environments will the company have once the company provisions environments to meet the requirements?
Select only one answer.
Two
Three (POP, Copilot)(Maybe correct)
Four(Bard)- Bard included production but POP didn’t consider production, – I selected
Five
You are deploying Microsoft Power Platform apps for a bank.
The new apps reside in five development environments: three quality assurance (QA) and two staging environments. The apps are then moved to the production environment.
What should you use to manage the lifecycle of the apps?Select only one answer.
Microsoft Power Platform Tool Installer
Microsoft Power Platform Build Tools(Bard)
Azure DevOps with PowerShell(Copilot, POP) – I selected
Microsoft Power Platform CLI
A company is using Dynamics 365 Project Operations.
You acquire an independent software vendor (ISV) solution from AppSource that contains several project charts and install the solution in the company’s environment.
You need to modify one of the charts.
In which solution area or layer does the chart reside?Select only one answer.
Runtime
Unmanaged(Unmanaged)
Managed (Bard) — I selected – Chances this is correct
Default
A bank has a department that deals with their clients’ investments and a separate department for credit activities.
You plan to design Microsoft Power Platform solutions to replace existing systems. You identify some requirements for each department.
You need to recommend a solution model.
What should you recommend?Select only one answer.
Two solutions, one for each department(Copilot)-I selected (Chances this is correct)
One solution with two patches, one per department(Bard)
One solution and one patch
Two solutions with two patches, one per department
You are creating a Microsoft Power Platform app for the provincial government of Quebec, Canada.
All data must be stored within Canadian geographical borders.
Which type of environment should you recommend?Select only one answer.
Sovereign cloud(Bard, POP) – I selected
Global cloud
Local cloud(Copilot)
On-premises
You need to categorize and document components used by your company’s Microsoft Power Platform environments.
What should you categorize as an environmental property?Select only one answer.
Microsoft Entra ID
Microsoft Entra ID security group(Bard) – I selected
Security roles(Copilot)
Power BI workspace
Dynamics 365 Business Central
You are creating a model-driven app for wedding planning. You have a Microsoft Excel workbook that contains email addresses and other contact information. The Excel data will be imported and used to send wedding invitations from the model-driven app through email.
A wedding planner will request musical group bids and select the top three bids. The wedding planner will assign tasks for specific wedding party members to complete. Wedding party members with tasks will have access to the model-driven app.
You need to create a custom table to manage some of the data.
Which data type requires the custom table?Select only one answer.
Musical group bids
Invitation responses
Wedding party assignments(Bard, Copilot, pop) – I selected
Guest names
A company is conducting data design sessions for each department that will move to a Microsoft Power Platform system.
Which two design patterns should you recommend for these sessions? Each correct answer presents a complete solution.Select all answers that apply.
Unified Modelling Language (UML) (POP)
Extract transform load (ETL) (Copilot, Bard) – I selected
Entity relationship diagram (ERD)(POP, Copilot, Bard) – I selected
Cumulative flow diagram (CFD)
You are developing a Microsoft Power Platform solution.
The data diagram has a large amount of information about the tables and their connections that makes it hard to use effectively.
What should you remove?Select only one answer.
Custom relationships to standard tables(Bard, Copilot) – I selected
Standard relationships to standard tables
Custom relationships to custom tables
Standard relationships to custom tables
A company plans to make historical communications available in timelines of Microsoft Dataverse records.
Most communications are with customers who exist in Microsoft Dataverse as contacts. The historical data is stored in an existing SQL repository.
You need to view the historical communications.
What should you do?Select only one answer.
Import the historical records into the activity tables, linking them to the customer records.
Import the historical records into a custom table, linking them to customer records.
Create a virtual entity for the communications connected to the SQL repository.(Bard, COpilot, POP) – I selected
Create an elastic table for communications.
You are developing a Power Apps app that processes sales transactions for a company’s conference exhibitor booth.
The app must interact with the company’s cloud-based ERP system to post submitted orders. The app must check a customer’s credit limit when starting a new order.
Which event framework stage should you recommend?Select only one answer.
PreOperation
PreValidation(Bard, Copilot, POP) – I selected
MainOperation
PostOperation
You are designing an app to collect votes for a county government election. The vote results will be captured in Microsoft Dataverse and need to be transferred to a custom location.
The app must process votes reliably.
What should you recommend?Select only one answer.
Azure Service Bus (Bard, Copilot) – I selected
Webhooks
Instant cloud flow
Classic workflow
Scheduled cloud flow
You need to design a solution to copy data from an accounting system into Microsoft Dataverse when data in the accounting system is updated by users.
Which two design patterns should you recommend? Each answer presents part of the solution.Select all answers that apply.
Change tracking (Bard, Copilot, Pop) – I selected
System jobs
Alternate keys
Upsert (Bard, Copilot, pop) – I selected
Server-side synchronization
You need to consolidate customer historical data from three SQL Server databases into Microsoft Dataverse.
You need to recommend a solution to ensure that source data is stored in a consistent format.
What should you recommend?Select only one answer.
Power Automate Desktop flows
Power Automate Scheduled flows
Virtual table
Data Integrator Platform(Bard, Copilot, POP) – I Selected
A company processes business transactions globally. Updated currency exchange rates must be available when transactions are entered each morning.
You are designing a solution that will obtain the currency exchange rates from an online service. The service only provides the daily exchange rate that is in effect at the time it is accessed. The exchange rates can be accessed via an OData (Open Data Protocol) RESTful API.
The solution must be able to use both current and historical exchange rates for currency translation.
Which two methods of data integration should you use? Each correct answer presents part of the solution.Select all answers that apply.
Push
Pull (Copilot, Bard, Pop)
Batch (Copilot, Pop)
Event
An organization’s employee data is stored in a Microsoft Dataverse table.
The data must only be accessible to human resources team users and to the employee’s manager.
You need to secure the employee data.
Which two actions should you perform? Each correct answer presents part of the solution.Select all answers that apply.
Implement identity governance.
Migrate the information to a new virtual table.
Migrate the information to a new table with user/team ownership.
Implement role-based security. (Bard, Copilot, POP) – I selected
Implement field-level security. (Bard, Copilot, Pop) – I selected
A law practice uses Microsoft Power Platform to manage their clients’ cases. They use Microsoft Teams for updates, training, and internal communications.
The legal team assigned to each client must be the only users that can access the client’s data.
The system administrator creating new users in Microsoft Power Platform must not have access to any client data.
Which security model should you use to secure the client data?Select only one answer.
Owner team
Access team(Bard, Copilot) – I selected
Private team
Microsoft Entra ID group
Environment security group
You create a canvas app for a company. Vendors use the app to accept or reject requests for service quotations.
You need to limit the canvas app access to only North American locations.
Which Microsoft Entra ID feature should you use?Select only one answer.
Multi-factor authentication
Identity governance
Conditional access(Bard, COpilot, Pop)
Hybrid identity
A financial institution uses a custom model-driven app. Financial advisors and telephone support employees use the app to manage customer records. Both employee types can read and update customer records.
The telephone support employees must not have access to certain information on the customer record.
You need to configure security for the telephone support employees.
What should you do?Select only one answer.
Hide fields by using client-side scripting.
Create a form for the financial advisors only and enable form-level security.
Create a restrictive security role for telephone support employees.(Once Copilot gave this option)
Restrict access to the fields by using column-level security.(Bard, Pop, Copilot) – I selected
You create a canvas app for a company. Vendors use the app to receive or reject service quotation requests.
You onboard a new vendor. You need to ensure that the new vendor can access the app.
Which three actions should you perform? Each correct answer presents part of the solution.Select all answers that apply.
Enable business-to-business (B2B) external collaboration for your tenant.(Copilot, pop, Bard) – I selected
Assign Microsoft Power Platform licenses to the vendor.(Copilot, pop, Bard) – I selected
Share the app with the vendor.(Copilot, pop, Bard)- I selected
Add the vendor to a Microsoft Office 365 group.
Enable business-to-business (B2B) external collaboration for the vendor’s tenant.
A temporary work agency manages employees and their work assignments using a Microsoft Power Platform app for several locations.
Wages are stored on the user record. All employees have access to view all user records.
The management staff who work at the agency’s main location are the only users allowed to view or update the employees’ wages for all locations.
Which type of security should you implement?
Select only one answer.
Manager hierarchical security
Column-level security
Row-level security(Bard, Copilot) – I selected
Access team security
A user at an organization is granted the Dynamics 365 administrator role. The user has no access to the environment settings area.
The user must be able to restrict access to the Microsoft Power Platform development environment to a specific group of people within the organization.
What should you do recommend?Select only one answer.
Assign the Microsoft 365 Global admin role to the user.
Assign the System administrator role to the user.
Add the user to the Office 365 group for the development environment.
Add the user to the development environment security group.(Bard, Copilot, pop) – I selected – Chances this is correct
Assign the Delegated admin role to the user.
You are developing a canvas app for submitting and approving employee expenses. The solution uses a Power Automate flow for expense approvals.
Each employee’s immediate manager is the primary approver and other business unit managers act as delegates.
Which security model should you recommend?
Select only one answer.
Team based
Managerial Hierarchy based(Bard, Copilot, pop) – I selected
Role based
Business unit based
Owner based
A company needs to create a Microsoft Power Platform app. The app will manage sensitive information about employees.
The app must provide employee information only to the employee’s immediate manager and that person’s manager. If an employee transfers to a different division, access transfers to the employee’s new manager and that person’s manager.
Which security model should you recommend?Select only one answer.
Business unit
Row level
Manager hierarchy(Bard, Copilot, pop) – I selected
Position hierarchy
Team owned
A company is preparing to go live with a new production system developed by using Microsoft Power Platform. User testing is complete and passed successfully.
Employees in each department use their own custom apps.
You need to plan for go-live.
What should you do?
Select only one answer.
Provide training data sets
Risk assessment
Security testing(Bard)- I selected
Environment setup(Copilot, Pop)
Latency tests
A company is ready to deploy a Microsoft Power Platform solution. The company provides you with files that contain test data for employee training.
You schedule four separate training sessions, each four hours long. You divide the employees into groups and assign each group to a training session.
You need to upload a new set of training data for each session while minimizing administrative effort and resources.
Which mechanism should you use?Select only one answer.
Dataflow (Bard)- Last time
Data template(Copilot, POP) – I selected
Azure Synapse Link
Third-party import tool
A company develops a Microsoft Power Platform solution. A user performs an end-to-end test of all processes prior to deploying the solution to production.
After deployment, you receive an email that sensitive employee data from the company’s ERP system has been viewed by multiple functional teams.
Which type of testing would have identified the data issue?Select only one answer.
User acceptance
Unit
Security(Copilot, Bard, Pop) – I selected
Integration
You are creating a model-driven app that uses standard tables for customer records.
You need to recommend a ready-to-use secure contract signature solution.
What should you recommend?Select only one answer.
GitHub
AppSource(Bard, PopAI) – I selected
Azure DevOps
Azure Marketplace(Copilot)
Failed in 1st attempt but cleared in 2nd attempt
