Exam PL-100 topic 3 question 60 discussion

Actual exam question from Microsoft's PL-100

Question #: 60
Topic #: 3

DRAG DROP -
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.
Select and Place:

Show Suggested Answer

Suggested Answer:

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 AliceVO at April 29, 2022, 2:41 p.m.

Comments

Submit Cancel

OCGMISP

Highly Voted 2 years, 9 months ago

Upload to OneDrive Create Dataflow Create queries Add conditional columns Append output from queries

upvoted 7 times

...

AliceVO

Highly Voted 3 years, 1 month ago

To be the right order would be: Step 1: Upload the worksheets to OneDrive Step 2: Create a dataflow - Step 3: Add conditional columns to perform checks on the data Step 4: Create queries for the worksheets Step 5: Append the output of the queries

upvoted 5 times

Aman66

2 years, 8 months ago

i think before you create queries you must need some extra cols to check their results, so ALICEVO's sol seems good

upvoted 2 times

...

Niharika06

Most Recent 12 months ago

Upload the worksheets to OneDrive: This is the first step as you need to have your data accessible online for further processing. Create queries for the worksheets: Once the worksheets are uploaded, you can create queries for each worksheet. This will allow you to manipulate and process the data. Add conditional columns to perform checks on the data: After creating the queries, you can add conditional columns to perform checks on the data. This can help you identify and handle duplicate rows. Append the output from the queries: After performing checks on the data, you can append the output from the queries. This will consolidate the data from the two worksheets. Create a dataflow: Finally, you can create a dataflow to import the consolidated data into a Microsoft Dataverse custom table.

upvoted 1 times

...