Exam PL-100 Topic 1 Question 91 Discussion

Actual exam question for Microsoft's PL-100 exam
Question #: 91
Topic #: 1
You store data about products in two Microsoft Excel worksheets.
The data contains duplicate rows.
You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Suggested Answer:


Explanation
Graphical user interface, text, application, email Description automatically generated

Step 1: Upload the worksheets to OneDrive
A data source needs to be specified. The data needs to be available.
Step 2: Create a dataflow
Step 3: Create queries for the worksheets
You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.
Step 4: Add conditional columns to perform checks on the data
Step 5: Append the output of the queries
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows
https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query

by Judy at Jan 05, 2024, 05:27 PM

Limited Time Offer

15%

Off

Get Premium PL-100 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10