Microsoft Power Platform Solution Architect (PL-600) Free Practice Test
Question 1
You are evaluating company data.
The data must be migrated to Microsoft Dataverse.
You need to recommend the process to ensure clean data for the migration.
Solution: Eliminate duplicate records.
Does the solution meet the goal?
The data must be migrated to Microsoft Dataverse.
You need to recommend the process to ensure clean data for the migration.
Solution: Eliminate duplicate records.
Does the solution meet the goal?
Correct Answer: A
Question 2
You need to recommend methods to resolve the organization's issues.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: Add users to Microsoft 365.
Scenario: Users cannot view Power BI reports within the Power Platform apps.
Issue: The people you share with may see a locked tile in a dashboard, or a " Permission required " message when they try to view a report.
Solution: You need to grant them permission to the underlying dataset.
Go to the All or the Datasets + dataflows tab in your content list.
Select More options (...) next to a dataset, then select Manage permissions.
Select Add user.
Enter the full email addresses for individuals, distribution groups, or security groups.
Select Grant access.
Box 2: Configure an on-premises data gateway.
Scenario: The company plans to reference historical data in the [on-premises] existing system. The records held in these systems will not be migrated to the new solution except for medication information.
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn ' t in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-troubleshoot-sharing
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/use-powerapps-checker
Question 3
You need to resolve the deployment plan issue.
What should you request?
What should you request?
Correct Answer: A
Question 4
A company is implementing Microsoft Power Platform The company deploys a solution by using Azure DevOps application lifecycle management (ALM).
Issues are reported after data migration.
You need to recommend a resolution for each issue.
Which resolutions should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Issues are reported after data migration.
You need to recommend a resolution for each issue.
Which resolutions should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Question 5
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.
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.
Correct Answer:
Explanation:
Question 6
A company uses Microsoft Power Platform and Microsoft Dataverse. The company enables auditing in the environment, tables, and at column level for all eligible tables and columns. You need to ensure audit history is available for all users. What should you do?
Correct Answer: A
Question 7
You are working with a customer to plan a go-live deployment to their production environment. The solution includes several apps and environment variables. The superuser team manages the production environment that is secured by using a specific environment Azure AD security group.
The following issues have been identified:
* The super user team cannot access make.powerapps.com to open and set the environment variables.
* Users are added to the environment Azure AD security group and are not able to access the model-driven app.
* Users are added to the environment Azure AD security group and are not able to access the canvas app.
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.
The following issues have been identified:
* The super user team cannot access make.powerapps.com to open and set the environment variables.
* Users are added to the environment Azure AD security group and are not able to access the model-driven app.
* Users are added to the environment Azure AD security group and are not able to access the canvas app.
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.
Correct Answer:
Explanation:
Question 8
You are a Microsoft Power Platform solution architect working on a project. API calls are being sent between external applications and a Microsoft Power Platform solution.
The number of requests per user within a given time frame varies. Some users may be exceeding the service protection API limits.
You need to ensure that the API conforms to service protection limits.
Which three metrics should you review? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
The number of requests per user within a given time frame varies. Some users may be exceeding the service protection API limits.
You need to ensure that the API conforms to service protection limits.
Which three metrics should you review? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,D,E
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 9
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?
Each correct answer presents part of the solution.
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?
Each correct answer presents part of the solution.
Correct Answer: A,D
Question 10
You need to recommend a solution for integrating luggage information.
What should you recommend? To answer, drag the appropriate types to the correct tables. Each type 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.
What should you recommend? To answer, drag the appropriate types to the correct tables. Each type 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.
Correct Answer:
Explanation:
Luggage: Custom activity table
An activity can be thought of as any action for which an entry can be made on a calendar. An activity has time dimensions (start time, stop time, due date, and duration) that help determine when the action occurred or will occur. Activities also contain data that helps determine what action the activity represents, for example, subject and description.
Passenger: Customer table
The account and contact tables in Microsoft Dataverse are essential for identifying and managing customers, selling products and services, and providing superior service to the customers. A customer address table is used to store address and shipping information for a customer.
Scenario: The company has a custom app for managing and tracking passenger luggage. The app uses Microsoft Dataverse.
Agents need to view which pieces of luggage match to each passenger, and then need to add the total on the passenger record.
Question 11
A company is implementing a Microsoft Power Platform solution.
You need to define the requirements.
Which requirement should you use for each topic? To answer, select the appropriate options in the answer area.
You need to define the requirements.
Which requirement should you use for each topic? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation:
Question 12
A bank is transforming its operations by using Microsoft Power Platform.
You lead a requirements workshop for the bank Several users request Microsoft Teams dialing capabilities in a canvas app so that they can call clients and record and transcribe client conversations.
You need to determine the feasibility of this requirement. Which feasibility challenge should you identify for this requirement?
You lead a requirements workshop for the bank Several users request Microsoft Teams dialing capabilities in a canvas app so that they can call clients and record and transcribe client conversations.
You need to determine the feasibility of this requirement. Which feasibility challenge should you identify for this requirement?
Correct Answer: B
Question 13
You need to recommend a solution to meet user interface requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: Create and embed a Power Bi radial gauge
A radial gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI). The line (or needle) represents the goal or target value. The shading represents the progress toward that goal. The value inside the arc represents the progress value. Power BI spreads all possible values evenly along the arc, from the minimum (left-most value) to the maximum (right-most value).
In this example, you ' re a car retailer tracking the sales team ' s average sales per month. The needle represents a 140 cars sales goal. The minimum possible average sales is 0 and the maximum is 200. The blue shading shows that the team is averaging approximately 120 sales this month.
Box 2: Add an inspection order to the work order form
You can add inspections to work orders in Dynamics 365 Field Service.
Field Service inspections are digital forms that technicians use to quickly and easily answer a list of questions as part of a work order. The list of questions can include safety protocols, pass-and-fail tests for a customer asset, an interview with a customer, or other audits and assessments performed before, during, or after a work order.
Example:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
https://docs.microsoft.com/en-us/dynamics365/field-service/inspections
Question 14
A company uses Microsoft Power Platform with assets that include solution files, flat files, custom code, HTML files, and data.
You need to use application lifecycle management (ALM) to deploy the assets to Microsoft Dataverse.
Which tool should you use?
You need to use application lifecycle management (ALM) to deploy the assets to Microsoft Dataverse.
Which tool should you use?
Correct Answer: C
Question 15
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? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
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? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,D