Question 234 of 388
Single answerHotspot QuestionYou have two CSV files named Products and Categories.The Products file contains the following columns:- ProductID- ProductName- SupplierID- CategoryIDThe Categories file contains the following columns:- CategoryID- CategoryName- CategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor. You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:- ProductID- ProductName- SupplierID- CategoryID- CategoryName- CategoryDescriptionHow should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.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.