A sales analyst has a table with columns: OrderID, ProductID, Quantity, and UnitPrice. They need to create a summary table showing total quantity and total sales amount per product. They also need to ensure the summary table can be refreshed efficiently. What should they do?

Pivot the ProductID column and sum the values.

Create a calculated column for LineTotal and then group by ProductID.

Group By ProductID and add aggregations for Sum of Quantity and Sum of UnitPrice * Quantity.

Load the raw table and create a DAX measure for total sales.

You have a Power Query query named 'BaseData' that loads from a SQL view. You need to create two separate queries: one that filters rows where Status = 'Active' and another that filters rows where Status = 'Inactive'. You also need to ensure that if the 'BaseData' query is modified (e.g., a new column is added), both derived queries automatically reflect the change. What should you do?

Merge 'BaseData' with itself and then filter on Status.

Duplicate 'BaseData' and apply the filters in each duplicate.

Create two new queries that directly query the SQL view with the filters, ignoring 'BaseData'.

Create references to 'BaseData' and apply the respective filters in each reference.

A financial analyst has a table with columns: Account, Q1, Q2, Q3, Q4. They need to create a chart that shows values by quarter for each account. What should they do in Power Query?

Unpivot the Q1-Q4 columns to create a 'Quarter' column and a 'Value' column.

Group By on Account with a sum of all quarters.

You are loading a CSV file that contains a 'Date' column with values like '2023-01-15' and a 'Revenue' column with values like '1,234.56'. You need to ensure that the Date column is recognized as a date type and the Revenue column as a decimal number for accurate time intelligence and calculations. What should you do in Power Query?

Change the data type of the Date column to Date and the Revenue column to Decimal Number.

Change the Date column to Text and the Revenue column to Whole Number.

Use the 'Replace Values' feature to convert the date format and revenue format.

Keep the columns as text and use DAX functions to convert them in the report.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 1–5

1foundation · easy
In a star schema, which type of table typically contains quantitative measures such as sales amount, quantity, or profit?
Select an answer first
2expert · hard
A sales analyst has a table with columns: OrderID, ProductID, Quantity, and UnitPrice. They need to create a summary table showing total quantity and total sales amount per product. They also need to ensure the summary table can be refreshed efficiently. What should they do?
Select an answer first
3expert · hard
You have a Power Query query named 'BaseData' that loads from a SQL view. You need to create two separate queries: one that filters rows where Status = 'Active' and another that filters rows where Status = 'Inactive'. You also need to ensure that if the 'BaseData' query is modified (e.g., a new column is added), both derived queries automatically reflect the change. What should you do?
Select an answer first
4application · medium
A financial analyst has a table with columns: Account, Q1, Q2, Q3, Q4. They need to create a chart that shows values by quarter for each account. What should they do in Power Query?
Select an answer first
5application · medium
You are loading a CSV file that contains a 'Date' column with values like '2023-01-15' and a 'Revenue' column with values like '1,234.56'. You need to ensure that the Date column is recognized as a date type and the Revenue column as a decimal number for accurate time intelligence and calculations. 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 1)

Questions 1–5

In a star schema, which type of table typically contains quantitative measures such as sales amount, quantity, or profit?

A sales analyst has a table with columns: OrderID, ProductID, Quantity, and UnitPrice. They need to create a summary table showing total quantity and total sales amount per product. They also need to ensure the summary table can be refreshed efficiently. What should they do?

A financial analyst has a table with columns: Account, Q1, Q2, Q3, Q4. They need to create a chart that shows values by quarter for each account. What should they do in Power Query?

Keep studying — Prepare the data