When importing a CSV file into Power Query, you receive an error that the file is not found. What is the most likely cause?

The file path is incorrect or the file has been moved

The file contains special characters

In Power Query Editor, where can you view and change the data type of a selected column?

In the Home tab, using the Refresh Preview button

In the Transform tab, using the Data Type drop-down

In the View tab, using the Column Profile option

In the Add Column tab, using the Custom Column button

A data analyst is profiling a dataset and notices that the 'CustomerID' column has a very high distinct count relative to the row count, and the 'OrderID' column has some duplicate values. The analyst needs to identify the primary key for the table. What should the analyst do?

Check the column statistics for 'OrderID' to see if duplicates are present.

Remove duplicate rows from the table.

Combine 'CustomerID' and 'OrderID' into a composite key.

Use the 'CustomerID' column as the primary key because it has a high distinct count.

A data analyst is cleaning a customer table and notices that the 'Phone' column contains values like '(555) 123-4567', '555-123-4567', and '5551234567'. The analyst needs to standardize the phone numbers to a single format for reporting. What should the analyst do in Power Query?

Change the column data type to Whole Number.

Remove all non-numeric characters and then format the digits.

Use 'Replace Values' to replace hyphens with parentheses.

Sort the column to group similar formats.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 2

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

35questions here

7free pages

7concepts

25–30%of the exam

Questions 1–5

1foundation · easy
When importing a CSV file into Power Query, you receive an error that the file is not found. What is the most likely cause?
Select an answer first
2foundation · easy
In Power Query Editor, where can you view and change the data type of a selected column?
Select an answer first
3foundation · easy
You discover a column contains values like -999 that represent missing data. What is the best practice to handle these unexpected values?
Select an answer first
4expert · hard
A data analyst is profiling a dataset and notices that the 'CustomerID' column has a very high distinct count relative to the row count, and the 'OrderID' column has some duplicate values. The analyst needs to identify the primary key for the table. What should the analyst do?
Select an answer first
5application · medium
A data analyst is cleaning a customer table and notices that the 'Phone' column contains values like '(555) 123-4567', '555-123-4567', and '5551234567'. The analyst needs to standardize the phone numbers to a single format for reporting. 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.