- (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?
Correct Answer:A
- (Exam Topic 5)
A company uses Dynamics 365 Supply Chain Management and Dynamics 365 Finance. User account data must be synchronized between the two system.
You need to ensure that the synchronized data is stored in one place. What should you use?
Correct Answer:B
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/data-integrator
- (Exam Topic 7)
You are creating Power Bl visualizations.
You need to display the visuals where a user can perform each function.
Which solution should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point.
Solution:
Text, letter Description automatically generated
Does this meet the goal?
Correct Answer:A
- (Exam Topic 5)
You need to use Microsoft Flow to perform data-management tasks when users interact with the sales opportunities in Dynamics 365.
Which three types of triggers can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Correct Answer:BCD
Triggers like When a record is created, When a record is updated, and When a record is deleted initiate your flow within a few minutes of the event occurring. In rare cases, your flow can take up to 2 hours to trigger.
Reference:
https://docs.microsoft.com/en-us/power-automate/connection-dynamics365
- (Exam Topic 2)
You create a business rule on contact entity to enforce the requirement that users must enter either a telephone number, fax number, or an email when creating a new record.
The company decides to remove fax number from the condition. You need to update the business rule.
What are two ways of achieving the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Correct Answer:AD
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-rules