Loading questions...
Updated
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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?
You design a Microsoft Power Platform app for a company.
The company has the following requirements:
• need to use an off-the-shelf product by an ISV that provides functionality to enable customers to deposit funds into their account
• ability to handle a high number of customers depositing funds into their account during lunchtime hours
You need to recommend a solution that meets the requirements.
Which components should you recommend?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A company has a call center that manages customer-related issues.
The company has the following customer experience improvement requirements:
• Simulate a human conversation with a customer by providing a chat interface.
• Ensure the initial conversation is passed to a live agent upon escalation.
You need to recommend a solution for each requirement.
Which solutions should you recommend? To answer, drag the appropriate solutions to the correct requirements. Each solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

An automobile parts manufacturer wants to replace an existing system with a Microsoft Power Platform solution. The company has been experiencing undesired data changes in their current system. The cause of the changes is due to the relationships that are set up between tables in the database that the system uses.
The new solution must meet the following requirements:
• Track vehicle manufacturers and models.
• Display a list of all models that a manufacturer produces.
• Ensure that each vehicle model can be associated to only one manufacturer.
• Delete all associated models when a user deletes a manufacturer.
• Automatically populate information from the manufacturer when creating a new model from the model list on the manufacturer page.
You need to recommend table relationships to meet the business requirements.
Which relationship settings should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A company plans to automate business processes by using Power Automate.
You identify a subprocess that must be implemented across multiple flows.
You need to implement the subprocess so that it is maintainable and easy to navigate.
What should you do?
You are implementing a Microsoft Power Platform solution for a customer to include data migration from multiple legacy systems. The data includes lead and contact data. The environment includes an assigned security group.
The following issues have occurred during a go-live deployment attempt:
• Lookup values are not populated when data migration is complete.
• Data is being added to the contacts table that is not part of the data migration.
• Various users do not appear in the list of users available for record assignment.
You need to resolve the go-live deployment issues.
How should you resolve the issue? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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 Microsoft Power Platform and Dynamics 365 Field Service.
External workers deliver onsite service to customer locations by using the Field Service (Dynamics 365) mobile app.
You need to ensure that external users can only use the app from specific locations.
Which solution should you use?
A company uses Power Pages for article submissions. The article properties are stored in a table in Microsoft Dataverse and the content of the article is stored in a related Microsoft SharePoint library.
The company invites different experts outside its organization to review an article before publishing it. The reviewers are granted access to the articles in Microsoft Dataverse.
The company has the following requirements:
• Provide a canvas app to the reviewers that exposes both the article properties and content in read-only mode.
• Once the review is completed, the reviewer saves the review data, and the article and the review no longer appear in the app.
You need to recommend the components to be used for each requirement.
Which options should you use?

A company uses a model-driven app to manage ticket requests.
The company has the following data requirements:
• Update a third-party application when a new ticket request is submitted.
• Transform and import event data nightly from a Microsoft Excel spreadsheet that is stored in a shared location.
You need to recommend a location to create the connection for each requirement.
Which locations should you recommend? To answer, drag the appropriate locations to the correct requirements. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

A company uses Microsoft Dataverse to store patient information.
Patient information is managed using Dataverse forms. The company must enforce the following rules to manage data quality:
• Show or hide tabs in the main form based on the column value selected.
• Add a discount code automatically when a new patient row is added.
You need to recommend a solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A police department uses apps deployed in Microsoft Power Platform to capture investigation information using a custom table. The apps run in offline mode in areas with poor data signals.
The department identified a need for photos to be captured during the investigation and stored in Microsoft Dataverse for easy access.
You need to implement the photo-capturing functionality.
Which four actions should you perform in sequence?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

A food distribution terminal uses Microsoft Dynamics 365 Field Service and Microsoft Dynamics 365 Supply Chain Management to manage inventory and fulfill customer orders. Customers place custom orders through a Power Pages customer portal. Customers can enter different receiving times and dates on fresh produce order lines.
The terminal needs to expose fresh produce order details from Dynamics 365 to its customers in the portal. Customers can control how much detail they see in the portal.
You need to design a solution that meets the requirements.
Which mechanism should you use for each requirement?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

A company uses two separate unlinked apps to manage sales leads; a Power Apps app and a third-party application.
The client has the following requirements:
✑ Manage all leads by using the Power Apps app.
✑ Create a lead in the Power Apps app when a user creates a lead in the third-party application.
✑ Update leads in the Power Apps app when a user updates a lead in the third-party application.
✑ Connect to the third-party application by using an API.
You need to recommend strategies to integrate the Power Apps app and the third-party application.
Which three options can you use to achieve the goal? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
HOTSPOT -
You are designing a Power Platform solution for a company that provides in-home appliance maintenance. When a customer schedules a service appointment, a dispatcher assigns one technician for a specific time and location.
The solution must capture information about the technician assigned to each appointment and the list of tools that the technician must bring to the appointment.
You need to recommend the data type for the captured information.
Which data type should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT -
A company offers continuing education courses for medical professionals. Each time a course is offered, the company tracks that the session has taken place in an Excel workbook.
The company maintains a list of required qualifications for an educator to teach a course. Educator qualifications range from languages spoken to advanced degrees.
The company needs the following custom table relationships defined:
✑ Associate educators with a list of their professional qualifications.
✑ Assign a primary educator to each course that is held.
✑ Collect information about every course that is held.
You need to determine the type of relationship that best fits the requirement.
Which type of table relationship should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

A company is implementing Dynamics 365 Sales.
The company has turned off out-of-the-box quote calculations in order to implement its own custom calculations.
When users update a line item on a quote, they expect to see an updated total for the quote in real time. Users are reporting inconsistent behavior, with some aggregations taking up to two hours.
You review the system design and notice many asynchronous workflows.
You need to recommend a solution to enable the calculation in real time.
Which two options should you recommend? Each answer presents a complete solution.
NOTE: Each correct selection is worth one point.
HOTSPOT -
A company uses Dynamics 365 Sales and Power BI.
Sales managers must be able to keep track of changes to their pipeline in the following ways:
✑ Notify the sales managers when an Opportunity changes sales stage.
✑ Notify the sales managers when the pipeline drops below 2.5M USD.
✑ When reviewing the pipeline in Power BI, a sales executive must be able to add a Playbook to an Opportunity.
You need to recommend a solution that meets the company requirements.
Which combination of solutions should you recommend? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You need to create an Agent security role.
Which three actions 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?
You are designing a database table for a client.
You have the following requirements:
✑ Maintain a comprehensive list of colors and their corresponding RGB values and hexadecimal values.
✑ Prevent the addition of duplicate colors based on the hexadecimal value for the color.
You need to recommend a design for the table.
Which two actions should the client perform after the table is created? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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?
A company uses manual processes to track interactions with customers. The company wants to use Power Platform to improve productivity.
The company has the following requirements:
✑ Provide customers with an online portal where they can submit and review cases.
✑ Ensure that customers can chat online with a customer service representative at any time.
✑ Route chats to customer service representatives based on skill and availability.
You need to recommend a solution to the company.
Which three components should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A client uses Dynamics 365 Sales, Power BI datasets, and Power BI dataflows.
The Dynamics 365 Sales implementation has security roles that restrict data export. You need to ensure that data has the same restrictions in Power BI as it does in Dynamics 365 Sales.
You need to design the security to avoid sensitive data from being seen.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.