Exam DP-500 topic 1 question 65 discussion

Actual exam question from Microsoft's DP-500

Question #: 65
Topic #: 1

HOTSPOT -
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission.
A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by AshwinN1992 at Jan. 4, 2023, 10:07 a.m.

Comments

Submit Cancel

SamuComqi

1 year, 10 months ago

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Join - LeftOuter

upvoted 3 times

...

Eltooth

2 years ago

Join LeftOuter

upvoted 1 times

...

DarioReymago

2 years, 2 months ago

in Power Q is joinNested and leftouter https://learn.microsoft.com/en-us/power-query/merge-queries-left-anti https://learn.microsoft.com/en-us/power-query/merge-queries-left-outer

upvoted 1 times

...