You have sales data for the current year stored in three separate Excel files, each with the same columns but different row counts. You need to combine them into a single query for analysis. However, you also need to ensure that the combined query can be refreshed without manual intervention when new files are added to the folder. What should you do?

Use the 'Folder' data source in Power Query to combine all files in the folder, and then append the resulting tables.

Manually append the three queries using the 'Append Queries' feature.

Create a calculated table in DAX that unions the three tables.

Use the 'Merge Queries' feature to join the three files on a common column.

A data analyst has a 'Status' column with values like 'Active', 'Inactive', and 'Pending'. They need to replace 'Pending' with 'Active' for reporting purposes. What should they do in Power Query?

Use Replace Values to change 'Pending' to 'Active'.

Use Group By on Status to aggregate.

Use Transpose to change orientation.

A manufacturing company receives monthly production data in a wide format: columns for each month (Jan, Feb, Mar, etc.) with values representing units produced. The data also includes a 'Plant' column. Analysts need to create a line chart showing production trends over time, with a single date axis. What should you do in Power Query to prepare this data?

Pivot the Plant column to create separate columns for each plant.

Group by Plant and sum the month columns, then keep the wide format.

Transpose the table so that months become rows and plants become columns.

Unpivot the month columns to create an 'Attribute' column for month names and a 'Value' column for units.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

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

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 21–25

21expert · hard
You have sales data for the current year stored in three separate Excel files, each with the same columns but different row counts. You need to combine them into a single query for analysis. However, you also need to ensure that the combined query can be refreshed without manual intervention when new files are added to the folder. What should you do?
Select an answer first
22application · medium
A data analyst has a 'Status' column with values like 'Active', 'Inactive', and 'Pending'. They need to replace 'Pending' with 'Active' for reporting purposes. What should they do in Power Query?
Select an answer first
23application · medium
A manufacturing company receives monthly production data in a wide format: columns for each month (Jan, Feb, Mar, etc.) with values representing units produced. The data also includes a 'Plant' column. Analysts need to create a line chart showing production trends over time, with a single date axis. What should you do in Power Query to prepare this data?
Select an answer first
24foundation · easy
In Power Query, after using Group By, which aggregation operation would you select to compute the average of a numeric column?
Select an answer first
25foundation · easy
You need to create a separate query that you can modify independently without affecting the original query. Which Power Query operation should you use?
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 5)

Questions 21–25

A data analyst has a 'Status' column with values like 'Active', 'Inactive', and 'Pending'. They need to replace 'Pending' with 'Active' for reporting purposes. What should they do in Power Query?

In Power Query, after using Group By, which aggregation operation would you select to compute the average of a numeric column?

You need to create a separate query that you can modify independently without affecting the original query. Which Power Query operation should you use?

Keep studying — Prepare the data