microsoft pl-200 practice test
Microsoft Power Platform Functional Consultant (beta)
Note: This exam has case studies
Question 1 Topic 4, Mixed Questions
HOTSPOT
You create a Power Automate flow as part of a managed solution. The flow alerts users when files are uploaded to a
SharePoint location.
Files are uploaded to SharePoint at a much higher rate than expected. Users report that they receive too many notifications
about uploaded files.
You need to stop the flow and correct the issue.
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:
Reference:
https://docs.microsoft.com/en-us/power-automate/edit-solution-aware-flow https://docs.microsoft.com/en-us/power-
automate/error-checker
Question 2 Topic 4, Mixed Questions
HOTSPOT
You are a Dynamics 365 help desk administrator.
You need to create a dashboard that displays information on help desk cases that are handled each week.
Which dashboard components should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Box 1: Area chart
Box 2: System chart
System charts are organization-owned charts, which makes them available to anyone with access to read the data running
the app. System charts can't be assigned or shared with specific app users.
Box 3: Personal dashboard
Box 4: Personal dashboard
Box 5: Area chart
Reference: https://docs.microsoft.com/en-us/powerapps/user/add-powerbi-dashboards https://docs.microsoft.com/en-
us/powerapps/maker/model-driven-apps/create-edit-system-chart
Question 3 Topic 4, Mixed Questions
HOTSPOT
You configure an alert in Power BI.
You need to alert users when the value of a tile exceeds a threshold. To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
Question 4 Topic 4, Mixed Questions
HOTSPOT
You have a model-driven app. You create five Microsoft Excel templates for analyzing customer data.
Four of the templates must be available to all users. The remaining template must be available only to you. You configure
the appropriate security roles for users.
You need to determine how to upload the Excel templates.
Which method should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Box 1: In the Settings menu, select Document Templates
Templates uploaded from the Settings page are available to all users. You don't need to take any further action.
Administrators can use the Settings page to upload the Excel template. A template uploaded in Settings is available to all
users.
For admins: Upload the Excel template
1. Go to Settings > Templates > Document Templates.
2. Click Upload Template.
3. Drag the Excel file into the dialog box or browse to find and upload the file.
4. Upload Template dialog box.
5. Click Upload.
Box 2: In the view for the email records, select Excel templates
Note: For non-admins or admins wanting to create a personal template: Upload the Excel template
Open a page with a list of records, for example, the list of Sales Opportunities. Go to Sales > Opportunities > My Open
Opportunities.
1. On the menu bar, click Excel Templates > Create Excel Template.
2. Click Excel Template > Upload.
3. Click Upload to add the Excel template.
4. Drag the file into the dialog box or browse to find and upload the file.
5. Click Upload.
Reference: https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
Question 5 Topic 4, Mixed Questions
You create a canvas app for a sales team. The app has an embedded Power BI tile that shows year-to-date sales. Sales
users do not have access to the data source that the tile uses.
Sales team users must be able to see data in the Power BI tile. You must minimize the level of permissions that you grant
and minimize administrative overhead.
You need to share another Power BI component to make the data visible.
What should you share?
- A. The Power BI dataset the tile uses as a data source.
- B. The Power BI workspace that includes the tile.
- C. The Power BI dashboard that includes the tile.
Answer:
C
Explanation:
Once shared, the PowerApps app will be accessible by all users who have permissions to access the app. However, in order
to make the Power BI content visible to those users, the dashboard where the tile comes from needs to be shared with the
user on Power BI. This ensures that Power BI sharing permissions are respected when Power BI content is accessed in an
app.
Reference:
https://powerapps.microsoft.com/en-us/blog/power-bi-tile-in-powerapps/
Question 6 Topic 4, Mixed Questions
A company uses Microsoft Teams. You plan to create a Power Apps app for Microsoft Teams.
You need to determine the environment that will used by the app.
Which environment will the app use?
- A. An existing Dataverse environment that you select.
- B. An existing Dataverse for Teams environment that you select.
- C. A Dataverse environment that is automatically created for the team.
- D. A Dataverse for Teams environment that is automatically created for the team.
Answer:
D
Explanation:
The Dataverse for Teams environment is automatically created for the selected team when you create an app or bot in
Microsoft Teams for the first time or install a Power Apps app from the app catalog for the first time. The Dataverse for
Teams environment is used to store, manage, and share team-specific data, apps, and flows. Each team can have one
environment, and all data, apps, bots, and flows created with the Power Apps app inside a team are available from that
team's Dataverse for Teams database.
Reference: https://docs.microsoft.com/en-us/power-platform/admin/about-teams-environment
Question 7 Topic 4, Mixed Questions
DRAG DROP
You are examining several processes to determine if you can automate the processes by using Power Automate.
The processes must run without human intervention when possible.
You need to determine which flow type should be used for each process.
Which flow type should you use? To answer, drag the appropriate processes to the correct flow types. Each process 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: Attended desktop flow
Desktop flows are used to automate tasks on the Web or the desktop.
To run an attended desktop flow, you need to have an active Windows user session that matches the name of the user
configured for your connection.
Note: Web applications are critical components of most organizations, and they are commonly used to access data from
servers.
Most CRM and ERP platforms run through web browsers, while the most popular business productivity tools are web
services. Web applications are unquestionably an integral part of the technological infrastructure of most companies.
To provide automation solutions for these applications, Power Automate Desktop supports all major browsers through its
web automation actions.
Box 2: Unattended desktop flow.
Unattended desktop flows are best for applications that do not need human supervision.
References: https://docs.microsoft.com/en-us/learn/modules/pad-web/1-introduction https://docs.microsoft.com/en-us/power-
automate/desktop-flows/run-pad-flow
Question 8 Topic 4, Mixed Questions
HOTSPOT
You have a business process flow (BPF) that interacts with the Account entity.
You modify the BPF and add a new stage at the beginning.
You need to identify the impact of the new version on the existing account records.
What is the outcome in each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Box 1: Existing accounts show the new BPF.
When an entity record is being created and if there are multiple BPFs defined on that entity. The system would do the
following:
If the ProcessId field is set to Guid.Empty. The system will skip defaulting the BPF on that instance.
If the ProcessId field is set to specific BPF entity reference. The system will default to the specified BPF. If the ProcessId
field on the record is not set. The system will default the BPF.
Box 2: No BPF is linked to a new account.
Note: A business process flow definition is represented as a custom entity and an instance of a process is stored as a record
within that entity. Each record is associated with a data record (such as an Account, Contact, Lead, or Opportunity) and in
case of cross-entity processes, with a data record for each participating entity.
Reference:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/business-process-flows-
overview
Question 9 Topic 4, Mixed Questions
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.
The sales team at a software company wants to attach a large number of supporting documents to customer records, but
management does not want to incur the cost of additional storage.
The company does not have any Office 365 application integrations enabled.
You need to recommend a storage solution that keeps storage costs low.
Solution: Enable Outlook integration.
Does the solution meet the goal?
- A. Yes
- B. No
Answer:
B
Explanation:
Instead enable server-based SharePoint integration.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/set-up-dynamics-365-online-to-use-sharepoint-online
Question 10 Topic 4, Mixed Questions
DRAG DROP
A company uses Common Data Service to store sales data.
For the past few quarters, the company has experienced a decrease in sales revenue. The company wants to improve sales
forecasting.
The company plans to use AI Builder to implement the solution. You select fields that will be used for prediction.
Which three 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.
Select and Place:
Answer:
Explanation:
Step 1:
Before you can use your prediction model, you have to train it to perform the way you want.
Step 2:
After you train your model, publish it to make it available.
Publish your model when you want to make it available to users in your Power Apps environment. Step 3: Use the model
with Power Apps
Reference:
https://docs.microsoft.com/en-us/ai-builder/prediction-train-model