A data analyst has a table where rows represent months and columns represent product categories. They need to restructure the table so that rows represent product categories and columns represent months. What should they do in Power Query?

Use Group By on the month column.

Use Unpivot Columns on the category columns.

Use Transpose to swap rows and columns.

Use Pivot Column on the month column.

You have a sales table with columns: OrderDate, Product, Region, and SalesAmount. You need to create a summary table that shows total sales per product per region. What should you do in Power Query?

Use the 'Append' feature to combine the Product and Region columns.

Use the 'Group By' feature to group by Product and Region, and sum the SalesAmount.

Use the 'Pivot' feature to pivot the Region column and sum SalesAmount.

Use the 'Transpose' feature to swap rows and columns, then sum SalesAmount.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

Transform and Load the Data PL-300 Practice Questions (Page 8)

Part of the Prepare the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 51 practice questions to prepare you well beyond it. (estimate)

51questions here

11free pages

16concepts

25–30%of the exam

Questions 36–40

36application · medium
A data analyst has a table where rows represent months and columns represent product categories. They need to restructure the table so that rows represent product categories and columns represent months. What should they do in Power Query?
Select an answer first
37foundation · easy
A column contains values like '1,234.56' and '987.65'. Which data type should you apply in Power Query to enable numeric aggregation and correct sorting?
Select an answer first
38foundation · easy
A column contains values like 'Cat', 'cat', and 'CAT'. Which Power Query transformation would standardize all values to lowercase?
Select an answer first
39foundation · easy
In Power Query Editor, which transformation would you apply to a column that contains leading and trailing spaces in text values?
Select an answer first
40application · medium
You have a sales table with columns: OrderDate, Product, Region, and SalesAmount. You need to create a summary table that shows total sales per product per region. What should you do in Power Query?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.

Transform and Load the Data PL-300 Practice Questions (Page 8)

Questions 36–40

A data analyst has a table where rows represent months and columns represent product categories. They need to restructure the table so that rows represent product categories and columns represent months. What should they do in Power Query?

A column contains values like '1,234.56' and '987.65'. Which data type should you apply in Power Query to enable numeric aggregation and correct sorting?

A column contains values like 'Cat', 'cat', and 'CAT'. Which Power Query transformation would standardize all values to lowercase?

In Power Query Editor, which transformation would you apply to a column that contains leading and trailing spaces in text values?

You have a sales table with columns: OrderDate, Product, Region, and SalesAmount. You need to create a summary table that shows total sales per product per region. What should you do in Power Query?

Keep studying — Prepare the data