A company wants to migrate 500,000 customer records from an external SQL database into Dataverse with minimal downtime. What is the best approach?

An organization requires that only authorized users can access specific Power Apps applications, while preventing unapproved app usage. What should be implemented?

A company wants to improve Power BI report performance for large datasets stored in Dataverse. What should be done?

A company wants to implement Power Apps on mobile devices but prevent users from downloading sensitive data locally. What should be done?

A company’s IT department wants to track all Power Automate flows, including failed runs and performance metrics. What is the best approach?

A company wants to automate customer onboarding by generating and sending customized contracts for electronic signing. What is the best solution?

A client needs a Power Platform solution that integrates with an external web service but requires minimal coding. What is the best approach?

A company is implementing a model-driven Power App for sales data management. To optimize performance, how should the solution architect minimize database lookups and improve efficiency?

A business requires a solution that automatically assigns cases to support agents based on their skillset and availability. Which approach should the solution architect recommend?

A company wants to allow external users to submit service requests via a Power Apps portal while ensuring authentication and access control. Which approach should be used?

Your organization wants to ensure that only managed solutions can be deployed in a production environment to maintain governance and stability. What should you configure?

A company needs to integrate a legacy on-premises ERP system with Dataverse to ensure real-time bidirectional synchronization. What is the best approach?

A customer wants to integrate a Power Virtual Agents bot with their on-premises SAP system to fetch live inventory data. What is the best approach?

A customer needs a solution where Power Apps users can edit customer data but must not delete records. Auditors should be able to view historical changes. What is the best approach?

A financial services company must ensure that only specific users can modify key business logic in a Power Automate flow while others can only execute it. What is the best way to achieve this?

A company wants to integrate Power Virtual Agents with an on-premises SQL database to provide real-time responses to customer queries. What is the most efficient approach?

A business wants to implement Power Apps portals for external customers, ensuring secure authentication and role-based access. Which authentication method should be recommended?

A company is implementing Power Platform solutions and needs to ensure that data governance policies are enforced, including restricting specific users from creating unmanaged solutions. What should you configure?

You are designing a Power Platform solution for a company that requires real-time data synchronization between Dynamics 365 and an external SQL database. The solution must be efficient and ensure minimal latency. What should you recommend?

An engineering company is implementing Dynamics 365 Sales. The company has a custom connector to an ERP system.

The company plans to use the connector to view data in the app while also avoiding any data migration.

You need to evaluate the requirements and recommend an approach. Which approach should you recommend?

You are a Microsoft Power Platform architect developing a solution for a car retailer. Your solution includes reference data that relates to car colors, car types, and car models. Automation has been developed and deployed to notify account managers based on the car color, car make, and car model selected by potential buyers.

Notifications are failing to send to account managers due to different record identifiers between environments.

You need to update the reference data across all environments.

What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

A company plans to automate the expense approval process.
Users currently enter data into an on-premises SQL Server database.
You need to allow users to submit expenses from mobile devices.
Solution: Create a canvas app for expense data entry. Create a custom connector. Create a cloud flow for approval and use the custom connector to add data to the SQL Server database.
Does the solution meet the goal?

A company plans to automate the expense approval process.
Users currently enter data into an on-premises SQL Server database.
You need to allow users to submit expenses from mobile devices.
Solution: Create a canvas app for expense data entry. Install the Power Automate app in Microsoft Teams. Create a cloud flow for approval to add data to the SQL Server database.
Does the solution meet the goal?

A company plans to automate the expense approval process.
Users currently enter data into an on-premises SQL Server database.
You need to allow users to submit expenses from mobile devices.
Solution: Create a canvas app for expense data entry. Install an on-premises gateway. Create a cloud flow for approval and to add data to the SQL Server database.
Does the solution meet the goal?

You are designing a new Microsoft Power Platform solution for a wedding organizer company.
The company uses a third-party application and plans to migrate the data into Microsoft Dataverse for the new solution. The third-party application has an API that can be connected to programmatically for data migration purposes.
You need to migrate the unique IDs belonging to the records from the third-party application.
Which two Microsoft Dataverse column types should you use to store this information?

You design integration with an external data source that uses sequential integer values as primary keys for the records contained in it. Data synchronization will occur in Microsoft Dataverse so users can access data.
Data within Microsoft Dataverse must be accurate against the data in the external data source.
You need to ensure that the data from the external data source does not create duplicated rows in Microsoft Dataverse.
Which two features should you use?

You are designing an authentication strategy.
You must provide users multiple primary authentication options for Microsoft Power Platform app sign-in events.
You need to select the primary authentication methods.
Which two authentication methods can you use? Each correct answer presents a complete solution.

You are designing forms for a Microsoft Power Platform solution.
Each person must see only the columns required for their department.

You need to ensure that the forms open correctly, display only the fields needed, and that data can be entered quickly. How should you design the form?

You are designing a Microsoft Power Platform solution for an automobile parts manufacturer. You create the following tables:

You are designing tables and columns for a Power Platform solution.
The solution will contain an interactive experience dashboard.
You need to ensure that the columns you create can be used as global filters for the dashboard.
Which two data types can you use? Each correct answer presents a complete solution.

You are designing a model-driven app that allows a company to manage sales opportunities.
The company has a complex security model that includes the following requirements:
✑ The vice president of sales must be able to see opportunities for sales managers and sales representatives.
✑ Sales managers must be able to see opportunities for all sales representatives.
✑ Sales representatives must only see opportunities that they own.
You need to recommend security tools for controlling user access.
Which two tools should you recommend? Each correct answer presents part of the solution.

A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft Power Platform solution.
You need to recommend a data-loading solution.
What should you recommend?

A company plans to implement robotic process automation (RPA).
The company wants to reuse existing online support content.
You need to recommend a component that uses the company's existing online support content.
Which component should you recommend?

A pharma company uses a proprietary system to manage its chemical experiments. The company uses Microsoft Dynamics 365 Project Operations to manage lab staff and resources.
Employees manually update Project Operations data with data from their proprietary system as needed. Employees are not able to provide a definite schema for their data.
You need to provide a solution that will allow employees to configure their own automatic updates.
Which component should you use?

A company uses a Microsoft Excel sheet to manage its loan application process.
The company wants to optimize the process.
You need to discover inefficiencies in the process.
Solution: Upload the activity data stored in the Excel sheet to the process advisor feature. Use task mining to discover inefficiencies in the process.
Does the solution meet the goal?

A company uses a Microsoft Excel sheet to manage its loan application process.
The company wants to optimize the process.
You need to discover inefficiencies in the process.
Solution: Record the actions required to complete the loan application process in the process advisor feature. Use task mining to discover inefficiencies in the process.
Does the solution meet the goal?

A company uses a Microsoft Excel sheet to manage its loan application process.
The company wants to optimize the process.
You need to discover inefficiencies in the process.
Solution: Record the actions required to complete the loan application process in the process advisor feature. Use process mining to discover inefficiencies in the process.
Does the solution meet the goal?

A company plans to use Microsoft Power Platform. The company gathers business requirements about data.
You need to identify the functional requirements.
Which two requirements about data should you gather? Each correct answer presents a complete solution.

A company uses a Microsoft Excel sheet to manage its loan application process.
The company wants to optimize the process.
You need to discover inefficiencies in the process.
Solution: Upload the activity data stored in the Excel sheet to the process advisor feature. Use process mining to discover inefficiencies in the process.
Does the solution meet the goal?

You design a Microsoft Power Platform solution for a company.
The company has an existing Azure SQL database with customer information that it wants to continue using. The company wants to share access to data that is held in Azure SQL with the following people:
• internal company employees, using built-in process functionality
• external customers to view their data
You need to recommend the appropriate components to use for the application.
Which two components should you recommend?

A car dealership has a custom financing table.
You are working with a developer to add a button to a ribbon that displays a hidden section of a form when specific criteria are met.
You need to recommend tools and technologies for the developer.
Which two tools or technologies should you recommend? Each correct answer presents part of the solution.

You are creating a scope of work document for a solution.
You have the following requirements:
✑ Track support cases, first response time, and resolution time.
✑ Include a chat-like interface that allows managers to check the status of cases with minimal manual searching.
✑ Allow cases to have multiple different priority levels.
You need to include the required Dynamics 365 and Microsoft Power Platform components.
Which two components should you include? Each correct answer presents part of the solution.

A company has an expense approval process that allows expenses to be submitted in multiple currencies.
An accountant converts the expense amount to USD as part of the approval process.
You need to automate the conversion by using the RESTful API.
What should you do?

You are assessing the capabilities of a project for a customer in the education sector.
The solution must meet the following requirements:
• Include curriculum and student management capabilities.
• Conform to on-going Microsoft platform upgrades.
• Minimize custom coding and configuration.
You need to recommend a solution.
What should you recommend?

You are designing a solution for a national vehicle repair company.
You have the following requirements:
✑ Customers must search for vehicle issues by using natural language expressions.
✑ Customers must contact a customer service agent as required.
You need to recommend a solution.
Which two features should you include? Each correct answer presents part of the solution.

An organization plans to implement a solution to deliver the complete sales process for its sales teams. The organization does NOT have any physical barcode scanners.
To meet the organization business requirements, the proposed solution must include the following capabilities:
✑ Create and qualify leads to contacts
✑ Generate quotes and convert quotes to orders
✑ Scan product barcodes as part of the order generation process
You need to recommend a solution to help the organization achieve its business requirements.
What should you recommend?

A company provides professional development certifications to technologies around the world. The company uses multiple call centers to support customers. The company plans to implement Dynamics 365 Customer Service.
The company must increase productivity for call center employees. The solution must meet the following requirements:
✑ Handle multiple customer interactions at once
✑ Ensure that users can access information from several business applications.
✑ Interact with customers by using the following channels: chat, phone calls, emails, and online reviews.
✑ Implement all functionality in a single interface.
You need to recommend a solution that meets the requirements of the company.
What should you recommend?

You are designing a Microsoft Power Platform solution to help a company manage sales leads.
The solution has the following requirements:
✑ Ensure that users follow a predefined sales process regardless of the device that employees use to access the app.
✑ Respond to sales events by using organization-defined best practices.
You need to recommend a component for the app.
What should you recommend?

A company is struggling to gather insights from won and lost opportunities.
Users must be able to access the company's solution from mobile and desktop devices. The solution must meet the following requirements:
✑ Track opportunities and reasons for the win or loss of opportunities in the context of other related data.
✑ Display data to users as charts and tables and provide drill-through capabilities.
You need to recommend a Power Platform tool to help the client visualize the data.
Which two technologies should you recommend? Each correct answer presents a complete solution.

A company has a website that contains a form named Contact Us. Data from completed forms is saved to a shared document. An office administrator periodically reviews the document. The office administrator sends new submissions to another employee who creates contacts or updates existing contacts.
You need to recommend a solution to automate the process.
What should you recommend?

A company has a custom web-based API that is hosted on Azure. You design a Microsoft Power Platform solution to provide the company additional capabilities.
You need to integrate the Microsoft Power Platform solution with the API.
What should you recommend?

You are designing a Power Platform solution.
The company wants its development team to adopt the construction of repeatable components for its implementation team to reuse on different entities and forms.
You need to recommend a technology that meets these requirements.
Which technology would you recommend the developers adopt to assist the implementation team?

You are a Power Platform consultant for an internet support company.
The company lacks a budget to buy third-party ISVs or add-ons.
The company requires a new system that achieves the following:
✑ All support issues must come in by email, need to be logged, and assigned to the support group.
✑ Accounts must synchronize with the parent company Oracle database.
✑ Reports must be sent to the executives on a weekly basis.
✑ No custom code will be used in the system.
You need to recommend the components that should be configured.
Which two components should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A large company experiences high staff turnover rates. As a result, the company must add or remove multiple system user accounts daily.
You need to recommend a security concept which will facilitate complex security profiles to entities for large groups of users across the Power Apps and Dynamics
365 applications.
What should you recommend?