PL-300 - Prepare the Data - Section 1.3

Profile and examine data to assess quality, structure, and distribution.

Interpret column quality, column distribution, and column profile statistics to locate errors, nulls, and data anomalies before loading. Distinguish between removing, replacing, or keeping null values based on the downstream impact on measures and relationships.

column qualitycolumn distributioncolumn profileerror and null handlingdata anomalies

Practice question for this objective

Free samplePrepare the Dataeasy

An analyst opens the Power Query Editor in Power BI Desktop and wants to turn on the column quality and column distribution features. Which ribbon tab exposes those options?

  • AThe Home tab, in the Reduce rows group, exposes the column quality and column distribution toggles.
  • BThe Transform tab, in the Any column group, exposes the column quality and column distribution toggles.
  • CThe View tab, in the Data preview group, exposes the column quality and column distribution toggles. Correct
  • DThe Add Column tab, in the General group, exposes the column quality and column distribution toggles.
Column quality, distribution, and profile are enabled on the View tab in the Data preview group. The data profiling tools article documents that to enable them in Power Query Desktop, the user goes to the View tab on the ribbon and enables the options in the Data preview group.

Why A is wrong: The Reduce rows group on the Home tab contains row-removal commands such as Remove errors and Keep rows, not data profiling toggles.

Why B is wrong: The Any column group on the Transform tab contains transformations such as Detect data type and Replace values, not profiling toggles.

Why C is correct: Correct. The data profiling tools article documents that to enable them in Power Query Desktop, the user goes to the View tab on the ribbon and enables the options in the Data preview group.

Why D is wrong: The General group on the Add Column tab contains custom and conditional column builders, not the data profiling preview toggles.

See more PL-300 practice questions, answers explained.

More in this domain

Back to all Prepare the Data objectives, or the PL-300 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.