Question 297 of 388
Single answerDrag and Drop QuestionIn Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.Every Product has a ProductSubCategory.Not every ProductsubCategory has a parent ProductCategory.You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge 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.
✓ASee source PDF for answer choices.
BAdditional option
✓
Correct Answer: A
See source PDF for answer choices.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.