PL-900 Free Practice Test

- (Exam Topic 7)
You are creating a Power Automate flow.
You need to retrieve data from several sources deluding Microsoft Excel, Azure Data lake, and GitHub.
What should you use? To answer, drag the appropriate components to the correct data sources. Each component 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

Solution:
Box 1: Formula
Reading an Excel document retrieves the data from the document, allowing it to be processed and modified in flows.
Read and extract data from an Excel document with the Read from Excel worksheet action.
Box 2: Connector
Azure Data Lake Store connector allows you to read and add data to an Azure Data Lake account. The Azure Data Lake connector is available for Power Automate.
Box 3: Expression Reference:
https://docs.microsoft.com/en-us/learn/modules/pad-excel-automation/3-reading-excel-document https://docs.microsoft.com/en-us/connectors/azuredatalake/

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 7)
You create a Power Bl dashboard.
Match each option to its requirement. To answer, drag the appropriate option from the column on the left to the correct requirement on the right. Each option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 7)
You are using the Power B1 service to view a visual on a report that has been shared with you. You need to add the visual to a dashboard as a tile. Which action should you perform?

1. A. Copy
2. B. Spotlight
3. C. Export data
4. D. Pin

Correct Answer: D

- (Exam Topic 2)
Your company wants to create a help desk system and implement Dynamics 365 Customer Service. The company has the following requirements:
Provide an application to allow support team staff to chat live with a customer.
Automatically import data from a Microsoft Excel spreadsheet once a day.
Provide a chatbot that can assist customers who need support.
You need to determine which applications to use to meet the requirements.
Which applications should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Graphical user interface, text, application, chat or text message Description automatically generated
Reference:
https://docs.microsoft.com/en-us/power-virtual-agents/fundamentals-what-is-power-virtual-agents
A 10-step Guide to Excel Automation using Power Automate Desktop | by Utkarsh Shahdeo | Medium

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 7)
You develop a Power Virtual Agents chatbot in a Microsoft Teams channel named Expenses. You need to identify the operations the chatbot can perform.
Which two actions can the chatbot perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. A. Transfer a chat to a live person if the chatbot cannot answer the question.
2. B. Staff who are not members of the Expenses team can use the chatbot.
3. C. Trigger a request for approval from a senior manager for high-value expenses.
4. D. Upload and process a PDF file.

Correct Answer: AC