☎  076 959 6407✉  support@quizcrazepro.co.za
Learn. Practice. Build your future.
BlogHelpContact

PL-300 Microsoft Power BI Data Analyst Exam Actual Questions

388 Questions120 Minutes70% Passing Score▣ Updated: Sep 2026

Question 234 of 388

Single answer
Hotspot 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.

About this practice exam

Review 388 Microsoft questions with answers and explanations. Use the navigation to move through the exam at your own pace.