Exam PL-900 topic 1 question 171 discussion

Actual exam question from Microsoft's PL-900

Question #: 171
Topic #: 1

DRAG DROP -
You are creating a Power Automate flow.
You need to retrieve data from several sources including 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.
Select and Place:

Show Suggested Answer

Suggested Answer:

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/

by SimpleHuman at May 10, 2022, 12:26 p.m.

Comments

Submit Cancel

DeVries

Highly Voted 2 years, 2 months ago

Microsoft Excel: Connector "Use a connector to import data from a selection of many different sources, such as Microsoft Excel, Azure, SQL Server database, SharePoint, Access, OData, and more." https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-import-export Data Lake: Connector "Azure Data Lake Store connector allows you to read and add data to an Azure Data Lake account." https://docs.microsoft.com/en-us/connectors/azuredatalake/ GitHub: Connector "With GitHub Connector, you can create a GitHub repo, create a pull request, merge a pull request, compare commits, trigger a GitHub actions workflow and much more from Power Apps and Power Automate." https://powerapps.microsoft.com/en-us/blog/github-connector-features-for-power-platform/

upvoted 39 times