PL-300 Prepare the data Practice Question
You are profiling data in Power Query Editor. Which THREE tasks can you perform using the Column Profile feature?
⚠ Common exam trap
Watch out — candidates often confuse the Column Profile feature (a read-only profiling tool) with data transformation actions like adding columns or replacing values, leading them to select options that are actually performed in other parts of Power Query Editor.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Identify data type issues
The Column Profile feature in Power Query Editor is a read-only data profiling tool, so it can identify data type issues (B) by showing errors and mismatches in the column statistics, which helps you spot columns that need type correction. It also counts distinct values (C), displaying the number of unique entries in the column profile pane to assess cardinality. Additionally, it shows the distribution of values (D) through value frequency charts and statistics such as count, min, max, and unique counts, helping you understand data patterns. The unmarked options do not belong because adding a conditional column (A) and replacing values (E) are data transformation operations performed via the Add Column and Transform ribbons, not tasks provided by the profiling feature.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a conditional column
Why it's wrong here
In Power Query Editor, adding a conditional column defines an if-then-else rule to create a new column, adding data to the model. Profiling, by contrast, is an observational activity that inspects existing columns for quality issues like errors, nulls, or data type mismatches without altering the data. It's a post-profiling cleanup step, not a profiling technique.
- ✓
Identify data type issues
Why this is correct
The column profile pane in Power Query Editor displays a range of statistics and data type indicators, making mismatches visually apparent—for example, a numeric column containing text values will show a 'Text' data type badge or error entries. Recognizing these issues is a primary objective of profiling so you can convert or correct types before loading. This is a capability of profiling, not a step you execute on data.
- ✓
Count distinct values
Why this is correct
The column profile pane's 'Distinct' value shows the number of unique entries in a column, while 'Unique' shows entries appearing exactly once, which together reveal cardinality and duplicate data. This is a key profiling metric because high cardinality may suggest keys, whereas low cardinality may indicate dimensions or categorical data. It's a read-only statistic, not a transformation, so it falls squarely under profile analysis.
- ✓
View the distribution of values
Why this is correct
The column profile graph visually renders each distinct value as a bar with its frequency, enabling you to quickly spot rare values, skewed distributions, or unexpected entries like empty string or error values. It also lets you see the percentage each value represents, which helps in identifying at what point nulls or duplicates become problematic. This is a direct product of profiling and cannot be achieved with a transformation step.
- ✗
Replace values
Why it's wrong here
Replace Values is a transformation step that permanently rewrites existing cell contents—for instance, changing 'N/A' to null—and therefore modifies the data itself. Profiling, conversely, is a non-destructive, analytical pass that evaluates data quality by measuring, not altering, values. You would perform a replace after profiling identifies the problem.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.