Exam DP-600 topic 1 question 169 discussion

Actual exam question from Microsoft's DP-600

Question #: 169
Topic #: 1

HOTSPOT
-

You have two Microsoft Power BI queries named Employee and Retired Roles.

You need to merge the Employee query with the Retired Roles query. The solution must ensure that duplicate rows in each query are removed.

Which column and Join Kind should you use in Power Query Editor? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

Show Suggested Answer

Suggested Answer:

by 0915fb2 at Jan. 21, 2025, 8:29 p.m.

Comments

Submit Cancel

4e5cf3d

4 weeks, 1 day ago

If you choose the column Role, it won't generate duplicates, since all the values are unique in Retired Roles table. I would select Role column and left join

upvoted 1 times

...

Pegooli

1 month ago

The question doesn't make sense because the assumption is incorrect. The answer can be Left Join or Inner Join

upvoted 1 times

...

0915fb2

3 months ago

How can a join ever remove duplicates at all? I dont understand this question.

upvoted 4 times

testtaker45

2 months, 4 weeks ago

They mean nulls, or only bring over matching values for sure right?

upvoted 2 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam