microsoft pl-200 practice test

Microsoft Power Platform Functional Consultant (beta)

Note: Test Case questions are at the end of the exam
Last exam update: May 17 ,2024
Page 1 out of 7. Viewing questions 1-15 out of 110

Question 1 Topic 4, Mixed Questions

You use Power BI Desktop to configure Power BI reports.
You need to create a canvas app that displays user account information and include the app in a Power BI report.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. From the Power Apps Insert menu, add a Power BI tile
  • B. From the Power BI Desktop menu, insert a Power Apps visual and include the required fields in the Power Apps data
  • C. Publish the report to the Power BI service
  • D. Connect to Common Data Service from Power BI Desktop
Answer:

B C D

User Votes:
A 1 votes
50%
B 2 votes
50%
C 1 votes
50%
D 2 votes
50%

Explanation:
Step 1 (B): Heres how we embed PowerApps into a Power BI report:
1. Download and login to the Power BI desktop application
2. Click on () and select Import from the marketplace.
Step 2: Open Power BI desktop and use Get data to connect with the Common Data Service data source.
Step 3: Publish the report to Power BI service.
Reference:
https://purple.telstra.com/blog/powerbi-integration-with-powerapps

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2 Topic 4, Mixed Questions

DRAG DROP
You create a report by using Power BI Desktop and publish the report to the Power BI service. You enable Power BI
visualization embedding in a model-driven app.
You need to configure the model-driven app to display a Power BI tile.
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: Create a personal dashboard in the model-driven app Add a Power BI dashboard to your model-driven app.
Step 2: Add a Power BI tile to the dashboard and select the Power BI dashboard in the app. Add one Power BI tiles to your
personal dashboard.
Step 3: Share the dashboard with the appropriate user in the app
Share the personal dashboard that contains Power BI visualizations: you must configure sharing in both Dataverse and
Power BI, and the user or group must have the same credentials and appropriate level of access in both services. To share
your personal dashboard in your app go to, Dashboards. In the list of dashboards, select the personal dashboard you want,
and then select SHARE DASHBOARD.
Reference: https://docs.microsoft.com/en-us/powerapps/user/add-powerbi-dashboards

Discussions
0 / 1000
AJTalsom
3 weeks, 2 days ago

Pin the Power BI to a new dashboard in the Powe BI service
Ensure the dashboard is available to the appropriate security roles
Add a Power BI tile to the dashboard and select the power BI dashbard in the app


Question 3 Topic 4, Mixed Questions

You create and publish a Power BI report that contains an embedded canvas app. The report will be used by multiple
people.
The canvas app has an issue that must be corrected.
You update the canvas app.
You need to ensure that the updated canvas app is available in the published Power BI report.
What should you do?

  • A. Manually refresh the data source on the published Power BI report
  • B. Publish the canvas app
  • C. Publish the Power BI report from Power BI Desktop and reshare to any users
  • D. Publish the Power BI report from Power BI Desktop
Answer:

A

User Votes:
A 2 votes
50%
B 1 votes
50%
C 1 votes
50%
D
50%

Explanation:
If you change the data fields associated with the visual, you must edit the app from within the Power BI service by

selecting the ellipsis (...) and then selecting Edit. Otherwise, the changes won't be propagated to Power Apps, and the app
will behave in unexpected ways.
The Power Apps visual can't trigger a refresh of Power BI reports and Power BI data sources from within Power BI

Desktop. If you write back data from the app to the same data source as the report, your changes won't be reflected
immediately in Power BI Desktop. Changes are reflected on the next scheduled refresh.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual#limitations-of-the-power-apps-
visual

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4 Topic 4, Mixed Questions

HOTSPOT
A company plans to implement AI Builder to add intelligence to several business processes.
Each business process uses different sources and produces different outputs.
You need to determine which AI Builder model types to use.
Which model types 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:
Reference: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-overview https://docs.microsoft.com/en-us/ai-
builder/entity-extraction-overview

Discussions
0 / 1000

Question 5 Topic 4, Mixed Questions

You manage the Dynamics 365 Customer Service environment for an organization.
Microsoft SharePoint will not be deployed in the environment for a year.
You need to integrate Microsoft Office 365 solutions with the Dynamics 365 instance to help the sales team with internal
collaboration efforts.
Which three solutions can you currently implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Microsoft Skype for Business
  • B. Microsoft Exchange Online
  • C. Microsoft OneNote
  • D. Microsoft Yammer
  • E. Microsoft OneDrive for Business
Answer:

A B D

User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D
50%
E 2 votes
50%

Explanation:
Reference: https://docs.microsoft.com/en-us/power-platform/admin/add-office-365-online-services

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6 Topic 4, Mixed Questions

You are a Dynamics Sales administrator for a car dealership. The dealership uses only out-of-the-box functionality. When a
new car is sold, the salesperson uses a Word template to generate a letter from the quote to thank the customer.
You need to determine if you can revise the template.
Which Word template change can you make?

  • A. Add the Discount field conditionally.
  • B. Format the table to have alternating color rows.
  • C. Format the Created On field to a long date format.
  • D. Add the address of the customer.
Answer:

D

User Votes:
A 2 votes
50%
B
50%
C 1 votes
50%
D 3 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7 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 OneDrive for Business.
Does this meet the goal?

  • A. Yes
  • B. No
Answer:

B

User Votes:
A 2 votes
50%
B 1 votes
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 8 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 OneNote integration.
Does this meet the goal?

  • A. Yes
  • B. No
Answer:

B

User Votes:
A
50%
B 1 votes
50%
Discussions
vote your answer:
A
B
0 / 1000

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 server-based SharePoint integration.
Does this meet the goal?

  • A. Yes
  • B. No
Answer:

A

User Votes:
A 2 votes
50%
B
50%

Explanation:
Reference: https://docs.microsoft.com/en-us/power-platform/admin/set-up-dynamics-365-online-to-use-sharepoint-online

Discussions
vote your answer:
A
B
0 / 1000

Question 10 Topic 4, Mixed Questions

The sales manager receives a list of leads from a partner company monthly. The field names that are provided do not match
the fields in Microsoft Dataverse tables. A data map does not exist.
You need to import the leads without changing the data from the partner company.
What should you do?

  • A. Create a data map on the first import by using the Import Data wizard.
  • B. Add a template for Import Data.
  • C. Use Import Field Translations.
  • D. Create a data map in Data Management.
Answer:

A

User Votes:
A 2 votes
50%
B
50%
C
50%
D
50%

Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/import-accounts-leads-
other-data

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11 Topic 4, Mixed Questions

HOTSPOT
A company uses Common Data Service to manage account and contact information.
The company plans to use the AI Builder model to make key business decisions.
You need to integrate prebuilt AI Builder models with Power Automate flows.
Which models 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:
Reference:
https://docs.microsoft.com/en-us/ai-builder/prebuilt-sentiment-analysis https://docs.microsoft.com/en-us/ai-builder/prebuilt-
key-phrase https://docs.microsoft.com/en-us/ai-builder/prebuilt-text-recognition

Discussions
0 / 1000

Question 12 Topic 4, Mixed Questions

You create a report by using Power BI Desktop and a Power BI dataset that is connected to Azure SQL Database.
Multiple groups of employees will use the report.
You need to ensure that each group of employees can see only data that pertains to their group.
What should you do?

  • A. Create and assign field security profiles.
  • B. Create and assign Common Data Service security roles.
  • C. Create and assign roles by using row-level security.
Answer:

C

User Votes:
A
50%
B 2 votes
50%
C
50%

Explanation:
You can use row-level security (RLS) with Power BI Desktop to restrict data access for given users. Filters restrict data at the
row level. You can define filters within roles.
You can now configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on
datasets that are using DirectQuery, such as SQL Server.
Incorrect Answers:
A: You can restrict access to a field by creating a field security profile. After you create the profile, you assign users and or
teams to that profile, and set up specific read, create, or write permissions for the field.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls

Discussions
vote your answer:
A
B
C
0 / 1000

Question 13 Topic 4, Mixed Questions

You are using Power BI to build a dashboard for a company.
You must make the dashboard available to a specific set of users, including employees and five external users. The number
of employees that require access to the dashboard varies, but is usually less than 100.
Employees and external users must not be permitted to share the dashboard with other users.
You need to share the dashboard with the employees and external users.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Create a dynamic distribution list. Add all users to the distribution list and use the list to share the dashboard.
  • B. Sign into the Power BI service. Open the dashboard and select Share.
  • C. Enter the individual email address of internal and external users.
  • D. Sign into Power BI Desktop. Open the dashboard and select Share.
  • E. Clear the Allow recipients to share your dashboard (or report) option.
  • F. Create a distribution list. Add all users to the distribution list and use the list to share the dashboard.
Answer:

B E F

User Votes:
A 2 votes
50%
B 1 votes
50%
C 1 votes
50%
D 1 votes
50%
E 1 votes
50%
F 1 votes
50%

Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 14 Topic 4, Mixed Questions

A company has a custom website.
You need to embed a Power Virtual Agents chatbot into the website.
What should you use?

  • A. Webpage URL
  • B. Form ID
  • C. Bot ID
  • D. Custom web channel
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%

Explanation:
Custom website: You can add your bot to a live website as an IFrame. Your live website can be a customer-facing external
website or an internal site, like a SharePoint or Yammer site.
You can also add the bot to your Power Platform admin center.
Add bot to your website:
1. Select Manage on the side navigation pane, and then go to the Channels tab.
2. Select Custom website and then select Copy to copy it directly to the clipboard, or Share to email to open a new email
message with the snippet included, in your default email app.
3. Provide the snippet to your web developer to add the bot to your website.
Reference: https://docs.microsoft.com/en-us/power-virtual-agents/publication-connect-bot-to-web-channels

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15 Topic 4, Mixed Questions

You are creating a Power Virtual Agents chatbot that uses multiple topics.
Each user interaction can reference more than one topic.
You need to be able to capture a value in an initial topic and use it in subsequent topics.
Which type of variable should you create?

  • A. Context
  • B. Bot
  • C. Topic
Answer:

B

User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%

Explanation:
Reference:
https://docs.microsoft.com/en-us/power-virtual-agents/authoring-variables-bot

Discussions
vote your answer:
A
B
C
0 / 1000
To page 2