microsoft pl-600 practice test
Microsoft Power Platform Solution Architect
Note: Test Case questions are at the end of the exam
Last exam update: Jul 20 ,2024
Question 1 Topic 7, Mixed Questions
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.
- A. Allocate Microsoft Dataverse capacity add-on subscriptions.
- B. Use the out-of-the-box User Summary report from the Reports section of the solution’s model-driven app.
- C. In the Power Platform admin center, review the Home tab Dataverse analytics dashboard.
- D. In the Power Platform admin center, review the Usage section of the Power Apps analytics dashboard.
- E. In the Power Platform admin center, review the Runs section of the Power Automate analytics dashboard.
Answer:
A C
Explanation:
A: When users exceed their limits, administrators can see this in the admin center (see below). You can do either one of the
following:
Adjust the app or flow to use fewer API requests
Purchase the Power Apps and Power Automate capacity add-on for your organization.
C: Home (default) Dashboard.
This is the default dashboard that provides information on the number of active Dataverse users, storage usage, the most
active workflows, and more.
API Calls: API Calls Number of API calls that were made by the Dataverse environment for the selected time period.
Reference: https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations
https://docs.microsoft.com/en-us/power-platform/admin/analytics-common-data-service
Question 2 Topic 7, Mixed Questions
A company has a Microsoft 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.
- A. Audit summary view
- B. Solution history
- C. SDK Message Processing Steps
- D. Plug-in trace log
- E. System job run history
Answer:
A B D
Explanation:
A: How to View Auditing Log Details?
System administrators can see activities for the entities that are enabled for audit logging. To view the audit logs:
1. Go to Settings > System >Auditing.
2. Choose Audit Summary View.
3. Under Audit Summary View, you will see the list of audit entries
B: You can view details about solution operations from the Solutions area of Power Apps. An operation can be a solution
import, export, or uninstall. The solution history displays information such as solution version, solution publisher, type of
operation, operation start and end time, and operation status.
D: Trace log records are written to the PluginTraceLog Table. Writing of these records is controlled by the trace settings
mentioned in Enable trace logging.
This data can be found in model-driven applications by navigating to Settings and choosing the Plug-in Trace Log tile.
Reference: https://www.sherweb.com/blog/dynamics-365/audits-dynamics-365/ https://docs.microsoft.com/en-
us/powerapps/developer/data-platform/logging-tracing
Question 3 Topic 7, Mixed Questions
DRAG DROP
You are designing data loss policies for a Microsoft Power Platform implementation.
You have the following requirements:
Solutions that use the HTTP connector must not include any other connectors.
Prevent the use of the Microsoft Forms connector. Allow the use of the Azure DevOps connector.
You need to determine in which data policy group to add each connector.
To which data policy group should you assign the connector? To answer, drag the appropriate setting to the correct drop
targets. Each source 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.
Select and Place:
Answer:
Explanation:
Box 1: 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.
Box 2: Non-business
DLP policies enforce rules for which connectors can be used together by classifying connectors as either Business or Non-
Business.
Box 3: Blocked
Sometimes you might want to block the usage of certain connectors altogether by classifying them as Blocked. Data policy
group Business blocked
Reference: https://docs.microsoft.com/en-us/power-platform/admin/wp-data-loss-prevention
Question 4 Topic 7, Mixed Questions
A local bank uses Microsoft Power Platform apps to store customer data.
The bank IT director discovers that all employees can see the social security numbers of their customers. The IT team does
not understand how field-level security works and needs help with the design.
You need to recommend a solution to the bank that meets the following requirements:
The system must restrict access to customer social security numbers to the vice president of finance only. The vice
president of finance must be able to read and update customer social security numbers.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the values for the read permission and for the update permission for social security number to yes.
- B. Enable field-level security for the member table.
- C. Create a field-level security profile.
- D. Enable field-level security for the social security number column.
Answer:
C D
Explanation:
Field-level security is managed by the security profiles. To implement field-level security, a system administrator performs
the following tasks.
1. Enable field security on one or more fields for a given entity.
2. Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access
to specific users or teams.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/field-level-security
Question 5 Topic 7, Mixed Questions
A company has a model-driven app. The app has forms with both Business Rules and JavaScript added to handle the
business logic on the form.
The form contains logic that is enforced by using business rules. The company wants to apply the business rules to all forms
in the app.
You need to recommend a simplified form setup so the form can be maintained moving forward.
What should you recommend?
- A. Manage the business logic with a Power Apps Component Framework (PCF) control.
- B. Evaluate whether complex parts of the logic can be solved by using Power Apps Component Framework (PCF) control. Use Business Rules for the remaining functionality.
- C. Remove the Business Rules and use only JavaScript.
- D. Update logic to ensure Business Rules are optimized. Use JavaScript for the remaining functionality.
Answer:
A
Explanation:
PCF controls are reusable.
Reference: https://docs.microsoft.com/en-us/powerapps/developer/component-framework/overview
Question 6 Topic 7, Mixed Questions
HOTSPOT
A company plans to deploy multiple Microsoft Dataverse environments. You are supporting the go-live process.
The company reports the following access issues:
Users can access account records but cannot read a column in the table.
A licensed user receives an insufficient permission error when opening leads.
A licensed user does not appear in the list of users available for security assignment.
You need to resolve the issues.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
References: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/field-security-entities
Question 7 Topic 7, Mixed Questions
A company provides mobile diagnostic imaging services. You are designing a Power Apps solution to manage patient
appointments and procedures.
Patient records are stored within the companys cloud patient billing system. The patient ID must be the only information
stored within the app. The patient name and date of birth must be visible to the technician to verify the patients identity.
You need to recommend a solution to display the patient information.
What should you recommend?
- A. Virtual table
- B. Business rule
- C. Privacy preference
- D. Data gateway
- E. Custom dataflow
Answer:
A
Explanation:
A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source.
Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database,
such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed
using the Dataverse web services.
Incorrect Answers:
D: The On-premises data gateway provides secure data transfer between on-premises data sources and your Azure
Analysis Services servers in the cloud.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-virtual-entities
Question 8 Topic 7, Mixed Questions
You are designing a Microsoft Power Platform solution for a company. The company issues each employee a tablet device.
The company wants to simplify the opportunity management processes and automate when possible. The company
identifies the following requirements:
Users must have a visual guide to know which data to enter in each step of the opportunity management process.
The system must automatically assign the opportunity to a manager for approval once all data is entered.
The system must notify an assignee each time an opportunity is assigned to them by using push notifications. When a
user selects a push notification, the associated opportunity must display.
You need to recommend the Microsoft Power Platform components that will meet their requirements.
Which three Microsoft Power Platform components should you recommend? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
- A. Power Apps mobile apps
- B. Power Automate desktop flows
- C. Power Automate cloud flows
- D. Power Virtual Agents chatbots
- E. Business process flows
Answer:
A C E
Explanation:
AC: Power Automate cloud flows
(The system must notify an assignee each time an opportunity is assigned to them by using push notifications.) To receive
push notification, each user must have opened the app in Power Apps Mobile.
E: Business process flows provide a guide for people to get work done. They provide a streamlined user experience that
leads people through the processes their organization has defined for interactions that need to be advanced to a conclusion
of some kind.
(Users must have a visual guide to know which data to enter in each step of the opportunity management process.)
Reference: https://docs.microsoft.com/en-us/power-automate/business-process-flows-overview
Question 9 Topic 7, Mixed Questions
You are designing a Microsoft Power Platform solution that uses Microsoft Dataverse.
You need to recommend a way to update currency exchange rates within Microsoft Dataverse.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Review AppSource for prebuilt solutions.
- B. Create a Power Automate flow that uses a custom connection or HTTP request to an outside source for exchange rates.
- C. Embed an iframe that points to a currency exchange service into a model-driven app.
- D. Use the Power BI connector to establish a link that updates Microsoft Dataverse with the current exchange rate.
Answer:
A B
Explanation:
B: We need is a source for exchange rates. There are some published connectors, but you also use a free service called
Exchange Rates API, which are based on the European Central Bank, and create a custom connection.
Now that we have our custom connector defined and have a way to request the latest exchange rates, the next step is to
create a Power Automate flow that will update all of currencies setup in our Dataverse environment.
Dataverse is a multicurrency system, in which each record can be associated with its own currency. This currency is called
the transaction currency. The multicurrency features enable users to perform financial transactions like opportunities, quotes,
orders, and invoices in multiple currencies. This feature also provides a currency choice to the end user when a financial
transaction occurs.
Reference:
https://readyxrm.blog/2021/03/10/updating-currency-exchange-rates-in-dataverse/
Question 10 Topic 7, Mixed Questions
You are designing a Microsoft Power Platform solution for an automobile parts manufacturer. You create the following tables:
You need to recommend a relationship behavior.
Which relationship behavior should you recommend?
- A. Referential, Restrict Delete
- B. Custom
- C. Parental
- D. Referential, Remove Link
Answer:
A
Explanation:
Restrict Delete: Prevent the Referenced table record from being deleted when referencing tables exist.
Incorrect Answers:
D: Remove Link: Remove the value of the referencing column for all referencing table records associated with the referenced
table record.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/configure-entity-relationship-cascading-behavior
Question 11 Topic 7, Mixed Questions
HOTSPOT
You are designing a model-driven app for a hospital. The app will be used to track teams at the hospital including:
You need to recommend the team types to use.
Which team types should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Box 1: Owner team
Owner team: An owner team owns records and has security roles assigned to the team. A user's privileges can come from
their individual security roles, those of the teams that they're part of or the ones they inherit. A team has full access rights on
the records that the team owns. Team members are added manually to the owner team.
Box 2: Access team
Access team: An access team doesn't own records and doesn't have security roles assigned to the team. The team
members have privileges defined by their individual security roles and by roles from the teams they're members of. These
members share records with an access team, and the team is granted access rights to the records. Access rights include
Read, Write, and Append. Box 3: Owner team
Reference: https://docs.microsoft.com/en-us/power-platform/admin/manage-teams
Question 12 Topic 7, Mixed Questions
You are designing a Microsoft Power Platform solution for a company that has multiple Microsoft Dataverse environments.
You need to prevent specific users from accessing specific environments.
What should you do?
- A. Remove all security roles from the users of the specific environments.
- B. Remove the user from the business unit.
- C. Remove the user from all security groups.
- D. Remove the user from all teams.
Answer:
A
Explanation:
Microsoft Dataverse uses a role-based security model to help secure access to the database. Security roles can be used to
configure environment-wide access to all resources in the environment.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
Question 13 Topic 7, Mixed Questions
HOTSPOT
An organization is optimizing its Microsoft Power Platform solution architecture.
The optimization needs to address the following:
Label names for option sets and multiselect option sets should be added as separate fields for reporting.
Users complain that when a case is assigned to another user, all the activities are also assigned. Some Power BI
reports based on Microsoft Dataverse data need near-real-time updating.
You need to recommend a design solution to meet these requirements.
What should you recommend? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Box 1: For each activity.. Cascade None: Do nothing
Note:
Cascade All: Perform the action on all referencing table records associated with the referenced table record.
Cascade Active: Perform the action on all active referencing table records associated with the referenced table record.
Box 2: Create Power BI reports using the Microsoft Dataverse connector
Use the Dataverse connector in DirectQuery mode: Connects directly to the data in Dataverse. Use this mode for real-time
data retrieval.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/configure-entity-relationship-cascading-behavior
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-powerbi-connector
Question 14 Topic 7, Mixed Questions
You are designing a Power Platform solution for a company.
Users must be granted access only to data that is relevant to them.
You need to recommend actions to meet the requirements.
Which two recommendations should you make? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Add column security profiles to applicable teams.
- B. Define and configure security roles.
- C. Create teams and assign security roles and users to the teams.
- D. Create business units and assign security roles to the business units.
Answer:
B D
Explanation:
To control data access, you must set up an organizational structure that both protects sensitive data and enables
collaboration. You do this by setting up business units, security roles, and field security profiles.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/security-roles-privileges
Question 15 Topic 7, Mixed Questions
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.
NOTE: Each correct selection is worth one point.
- A. Multiline Text
- B. Choice
- C. Text
- D. Yes/No
- E. Lookup
Answer:
B D
Explanation:
With interactive dashboards, a chart uses the color assigned to the categories that make up the different values, even if the
chart is configured to use random colors, when the chart is configured to be grouped by any of the following column types:
Choice
Yes/No Status Reason
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards