You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use? Each correct answer presents a…

The correct answer is B. Column distribution C. Column profile. Column Distribution (B) shows a bar chart of value frequency and displays counts of distinct vs. unique values, immediately revealing whether all values are unique. Column Profile (C) provides detailed statistics including distinct count and unique count, also indicating…

Submitted by yaw92· Apr 18, 2026Prepare the data

Question

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

Options

AShow whitespace
BColumn distribution
CColumn profile
DColumn quality
EMonospaced

How the community answered

(26 responses)

A
8% (2)
B
88% (23)
D
4% (1)

Explanation

Column Distribution (B) shows a bar chart of value frequency and displays counts of distinct vs. unique values, immediately revealing whether all values are unique. Column Profile (C) provides detailed statistics including distinct count and unique count, also indicating uniqueness. Column Quality only shows valid/error/empty percentages. Show Whitespace and Monospaced are display formatting options unrelated to value uniqueness.

Topics

#Power Query Editor#Data profiling#Column uniqueness#Data preview

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice