HOTSPOT

You are designing the security model for a Power Platform solution.

The security model must meet the following requirements:

✑ Restrict sharing of data between Power Automate connectors.

✑ Ensure that environment administrators only see users who require access in the enabled user list.

You need to recommend security features for the solution.

What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Data loss prevention policy

Data loss prevention (DLP) policies enforce rules for which connectors can be used together by classifying connectors as either Business or Non-Business. If you put a connector in the Business group, it can only be used with other connectors from that group in any given app or flow. Sometimes you might want to block the usage of certain connectors altogether by classifying them as Blocked.

Box 2: Security group

If your company has multiple Microsoft Dataverse environments, you can use security groups to control which licensed users can be a member of a particular environment.

Reference:

https://docs.microsoft.com/en-us/power-platform/admin/wp-data-loss-prevention

https://docs.microsoft.com/en-us/power-platform/admin/control-user-access

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.

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Microsoft Power Automate, Microsoft Dataverse connector, and Microsoft 365 Outlook connector

Use Microsoft Dataverse as the data source.

While Power Automate is a robust tool with ever-expanding capabilities, it also handles simple tasks with grace. A universal business need for many organizations is the ability to automate email notifications based on certain criteria: an opportunity is won, send an email to the sales manager; a case is closed, send an email to the customer; a work order is completed, send an email to the customer.

Power Automate can easily accommodate this using the Microsoft 365 Outlook connector.

Box 2: Microsoft Power Automate, Power Bi data alerts, and Microsoft 365 connector Data alerts in the Power BI service: Set alerts to notify you when data in your dashboards changes beyond limits you set.

Box 3: Microsoft Power Automate, Power BI, Power Apps, and Microsoft Dataverse connector

Reference:

https://www.velosio.com/blog/2021/01/27/tracking-emails-the-right-way-with-power-automate/

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

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.

Reveal Solution Hide 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. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf.

The company must import the data from the existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution.

You need to recommend a solution to combine the room and shelf fields into a single column during the import process.

Which tool should you recommend?

Reveal Solution Hide Solution

A company has a Power Platform environment that connects to a third-party marketing application.

The company reports that the data in the Power Platform lead table does not match data from the marketing application.

Issues include:

✑ The owner data in the lead table and the third-party application do not match.

✑ The Topic column has more information than the related record from the marketing application.

✑ There are differences in how telephone numbers are formatted.

✑ You need to determine which processes are causing the issues.

Which three processes may be causing the differences observed? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

HOTSPOT

A company has a Power Platform environment that connects to a third-party marketing application.

The company reports that the data in the Power Platform lead table does not match data from the marketing application.

Issues include:

– The owner data in the lead table and the third-party application do not match.

– The Topic column has more information than the related record from the marketing application.

– There are differences in how telephone numbers are formatted.

You need to determine which processes are causing the issues.

Which three processes may be causing the differences observed? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Increase multithreading and/or batch size settings

Box 2: Ensure you are loading data in a specific order.

Load the base tables in the hierarchies first.

A company has a Power Platform solution that integrates with a third-party system.

The client reports that unexpected updates are being made to the Accounts table.

You need to determine the root cause of the issue.

In which three locations should you investigate? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You are designing a Power Platform solution.

During quality assurance testing the API limits are reached.

You need to identify and resolve the issue.

Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution