A data analyst is importing data from an Excel workbook. The import fails with an error stating that a column contains mixed data types. The analyst needs to resolve the error so that the data loads correctly. What should the analyst do first?

Remove the column from the query to avoid the error.

Open the source file and manually correct the mixed-type values.

In the Power Query editor, review the column and replace or convert the offending values to a consistent type.

Change the column data type to 'Any' in the Power Query editor.

A data analyst imports a table of customer orders. The 'Discount' column contains nulls for about 30% of rows. The analyst needs to ensure that calculations involving total revenue are not affected by missing discount values. The business rule is that a null discount means no discount was applied. What should the analyst do in Power Query?

Leave the nulls as-is and handle them in DAX measures.

Replace nulls with the average discount of non-null rows.

Remove rows that have nulls in the 'Discount' column.

Replace nulls with 0 in the 'Discount' column.

A data analyst is importing data from an Excel file that has multiple sheets. The import fails because one sheet has a column with mixed data types (numbers and text) in the same column. The analyst needs to import all sheets successfully. What should the analyst do?

Use the 'Combine Files' feature to merge all sheets.

Skip the problematic sheet during import.

Change the data type of the column to Text in the source Excel file.

Import each sheet separately and clean the problematic column in Power Query.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 2

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

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 11–15

11foundation · easy
In Power Query Editor, which pane provides a quick view of column statistics such as count, distinct count, empty count, and min/max values?
Select an answer first
12foundation · easy
In Power Query Editor, which transformation allows you to replace unexpected values like 'N/A' with a blank or a specific value?
Select an answer first
13application · medium
A data analyst is importing data from an Excel workbook. The import fails with an error stating that a column contains mixed data types. The analyst needs to resolve the error so that the data loads correctly. What should the analyst do first?
Select an answer first
14application · medium
A data analyst imports a table of customer orders. The 'Discount' column contains nulls for about 30% of rows. The analyst needs to ensure that calculations involving total revenue are not affected by missing discount values. The business rule is that a null discount means no discount was applied. What should the analyst do in Power Query?
Select an answer first
15expert · hard
A data analyst is importing data from an Excel file that has multiple sheets. The import fails because one sheet has a column with mixed data types (numbers and text) in the same column. The analyst needs to import all sheets successfully. What should the analyst do?
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 3)

Questions 11–15

In Power Query Editor, which pane provides a quick view of column statistics such as count, distinct count, empty count, and min/max values?

In Power Query Editor, which transformation allows you to replace unexpected values like 'N/A' with a blank or a specific value?

A data analyst is importing data from an Excel workbook. The import fails with an error stating that a column contains mixed data types. The analyst needs to resolve the error so that the data loads correctly. What should the analyst do first?

A data analyst is importing data from an Excel file that has multiple sheets. The import fails because one sheet has a column with mixed data types (numbers and text) in the same column. The analyst needs to import all sheets successfully. What should the analyst do?

Keep studying — Prepare the data