You have a column with values like 'New York', 'NYC', and 'New York City'. What type of data inconsistency is this?

Inconsistent naming conventions

A data analyst imports a survey response table. The 'Age' column contains values like 25, 30, 'forty', and -5. The analyst needs to analyze age demographics. What should the analyst do to handle the unexpected values?

Replace negative values with the average age.

Replace 'forty' with 40 and remove negative values.

Remove all rows that contain any non-numeric characters.

Change the data type to Whole Number and let Power Query handle errors.

A data analyst is importing a CSV file into Power Query. The import fails with an error stating that the file contains more columns than expected. The analyst opens the file in a text editor and sees that some rows have extra commas. What should the analyst do to resolve the import error?

Change the file extension to .txt and import as a text file.

Edit the CSV file to remove the extra commas from the affected rows.

Use the 'Split Column by Delimiter' feature after importing with a custom delimiter.

In the import dialog, set the delimiter to 'Tab' instead of 'Comma'.

While importing data from an Excel workbook, you get an error that the sheet name is invalid. What should you check?

The file is saved in the correct format

The sheet name in the connection string matches the actual sheet name

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 2

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

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 16–20

16foundation · easy
Which Power Query transformation replaces null values in a column with a specified value?
Select an answer first
17foundation · easy
You have a column with values like 'New York', 'NYC', and 'New York City'. What type of data inconsistency is this?
Select an answer first
18application · medium
A data analyst imports a survey response table. The 'Age' column contains values like 25, 30, 'forty', and -5. The analyst needs to analyze age demographics. What should the analyst do to handle the unexpected values?
Select an answer first
19application · medium
A data analyst is importing a CSV file into Power Query. The import fails with an error stating that the file contains more columns than expected. The analyst opens the file in a text editor and sees that some rows have extra commas. What should the analyst do to resolve the import error?
Select an answer first
20foundation · easy
While importing data from an Excel workbook, you get an error that the sheet name is invalid. What should you check?
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.