A data analyst is working with a dataset that has a 'Score' column with nulls. The analyst needs to calculate the average score, but the business wants to exclude nulls from the calculation. The analyst also needs to keep the nulls in the dataset for other analyses. What should the analyst do?

Replace nulls with 0 in Power Query.

Create a calculated column that replaces nulls with the average.

Filter out nulls in Power Query.

Leave the nulls in the dataset and use a DAX measure that ignores nulls.

A data analyst loads a sales table with a 'Revenue' column. In Power Query, the column shows a data type of 'Any' and the Column Statistics pane displays a Count of 1000, but the Distinct Count is 850. The analyst needs to ensure the column is treated as a numeric value for future calculations. What should the analyst do first?

Sort the column in ascending order.

Change the column data type to Decimal Number.

Remove rows with duplicate values in the column.

Replace null values in the column with zero.

A data analyst is importing data from a SQL Server database. The import fails because the 'OrderID' column is defined as an integer in the source, but some values exceed the integer range. What should the analyst do to resolve this import error?

Change the data type of the column to Decimal in Power Query.

Remove the column from the query.

Modify the source query to cast the column to a larger data type, such as BIGINT.

Use the Replace Errors feature to replace the out-of-range values with null.

A data analyst notices that the 'Country' column in a dataset contains 'USA', 'U.S.A.', and 'United States'. The analyst needs to standardize these to 'United States' for consistent reporting. What should the analyst do in Power Query?

Use the Trim feature to remove spaces from the values.

Use the Replace Values feature to replace 'USA' and 'U.S.A.' with 'United States'.

Use the Group By feature to combine the variations.

Use the Conditional Column feature to create a new column with the standardized values.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 2

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

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 31–35

31foundation · easy
When profiling data in Power Query Editor, which statistic is most useful for identifying whether a column contains duplicate values?
Select an answer first
32expert · hard
A data analyst is working with a dataset that has a 'Score' column with nulls. The analyst needs to calculate the average score, but the business wants to exclude nulls from the calculation. The analyst also needs to keep the nulls in the dataset for other analyses. What should the analyst do?
Select an answer first
33application · medium
A data analyst loads a sales table with a 'Revenue' column. In Power Query, the column shows a data type of 'Any' and the Column Statistics pane displays a Count of 1000, but the Distinct Count is 850. The analyst needs to ensure the column is treated as a numeric value for future calculations. What should the analyst do first?
Select an answer first
34application · medium
A data analyst is importing data from a SQL Server database. The import fails because the 'OrderID' column is defined as an integer in the source, but some values exceed the integer range. What should the analyst do to resolve this import error?
Select an answer first
35application · medium
A data analyst notices that the 'Country' column in a dataset contains 'USA', 'U.S.A.', and 'United States'. The analyst needs to standardize these to 'United States' for consistent 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.

No more pagesBack 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.