A data analyst loads a sales table and uses the Column Statistics pane to review the 'Quantity' column. The statistics show a Min of 0, Max of 1000, and a large number of null values. The analyst needs to understand the distribution of non-null values. What should the analyst do next?

Replace nulls with the average quantity.

Sort the column by the null values.

Remove rows with null Quantity.

Create a histogram or use the 'Column distribution' view.

A data analyst is cleaning a dataset of product categories. The 'Category' column contains values like 'Electronics', 'electronics', 'Electronics ', and 'Consumer Electronics'. The analyst needs to ensure that all categories are consistently named and that 'Consumer Electronics' is treated as a separate category from 'Electronics'. What should the analyst do?

Use the Conditional Column feature to create a new column that maps all variations to a single 'Electronics' value.

Use the Replace Values feature to replace 'electronics' with 'Electronics' and leave 'Consumer Electronics' as-is.

Trim the column and then use Replace Values to map 'electronics' to 'Electronics'.

Use the Group By feature to combine 'Electronics' and 'Consumer Electronics'.

A data analyst is cleaning a dataset of customer feedback scores. The 'Score' column contains values from 1 to 5, but some rows contain the value 0. The business rule is that 0 is not a valid score. What should the analyst do in Power Query?

Replace 0 with the average score.

Change the data type of the Score column to text.

Remove all rows where Score is 0.

A data analyst loads an order table where the 'ShipDate' column has null values for orders that are still in processing. The analyst needs to calculate average shipping time in days for completed orders only. What should the analyst do in Power Query?

Replace null ShipDate values with the OrderDate.

Leave the nulls and calculate the average in a measure.

Replace null ShipDate values with today's date.

Filter out rows where ShipDate is null.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 2

Profile and Clean 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 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

7concepts

25–30%of the exam

Questions 21–25

21application · medium
A data analyst loads a sales table and uses the Column Statistics pane to review the 'Quantity' column. The statistics show a Min of 0, Max of 1000, and a large number of null values. The analyst needs to understand the distribution of non-null values. What should the analyst do next?
Select an answer first
22expert · hard
A data analyst is cleaning a dataset of product categories. The 'Category' column contains values like 'Electronics', 'electronics', 'Electronics ', and 'Consumer Electronics'. The analyst needs to ensure that all categories are consistently named and that 'Consumer Electronics' is treated as a separate category from 'Electronics'. What should the analyst do?
Select an answer first
23foundation · easy
In Power Query Editor, which option in the 'Transform' tab allows you to replace null values with the last non-null value in a column?
Select an answer first
24application · medium
A data analyst is cleaning a dataset of customer feedback scores. The 'Score' column contains values from 1 to 5, but some rows contain the value 0. The business rule is that 0 is not a valid score. What should the analyst do in Power Query?
Select an answer first
25application · medium
A data analyst loads an order table where the 'ShipDate' column has null values for orders that are still in processing. The analyst needs to calculate average shipping time in days for completed orders only. What should the analyst 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.

Profile and Clean the Data PL-300 Practice Questions (Page 5)

Questions 21–25

A data analyst loads a sales table and uses the Column Statistics pane to review the 'Quantity' column. The statistics show a Min of 0, Max of 1000, and a large number of null values. The analyst needs to understand the distribution of non-null values. What should the analyst do next?

In Power Query Editor, which option in the 'Transform' tab allows you to replace null values with the last non-null value in a column?

A data analyst is cleaning a dataset of customer feedback scores. The 'Score' column contains values from 1 to 5, but some rows contain the value 0. The business rule is that 0 is not a valid score. What should the analyst do in Power Query?

A data analyst loads an order table where the 'ShipDate' column has null values for orders that are still in processing. The analyst needs to calculate average shipping time in days for completed orders only. What should the analyst do in Power Query?

Keep studying — Prepare the data