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

zxc01

1 month, 2 weeks ago

The first answer should be Role(1) and Division(2) because we can see these columns have been selected on table Retired Roles. Second answer should be Inner join.

upvoted 1 times

...

4e5cf3d

2 months, 3 weeks 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

Sr18

1 month ago

Question is very vague. Specially if you can't see the full dataset. But with what we can see. Joining over "Role" is good, considering the fact that both tables don't have duplicates. But it will be good to have INNER JOIN, just to make sure if any role is missing in Retried Roles it should not create an null data.

upvoted 1 times

...

Pegooli

2 months, 3 weeks 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

4 months, 4 weeks ago

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

upvoted 4 times

testtaker45

4 months, 3 weeks ago

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

upvoted 2 times

...