Exam PL-300 topic 2 question 87 discussion

DRAG DROP
-

You use Power Query Editor to import three tables named Customers, Address, and Country.

In the source system, not every customer has a related address, but every address has a related country.

You need to merge all the tables into a single query. The solution must optimize query refresh performance.

Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Suggested Answer: