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.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
