Home » Microsoft » DA-100 v.2 » Which two Data Preview options can you use?
You are reviewing a query that produces 10,000 rows in the 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.
A. Column profile
B. Column distribution
C. Show whitespace
D. Column quality
E. Monospaced
Correct Answer: AB
Explanation/Reference:
Explanation:
B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).
A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.
Incorrect Answers:
D: Column quality
The column quality feature labels values in rows in three categories:
Valid, shown in green
Error, shown in red
Empty, shown in dark grey
Reference:
https://docs.microsoft.com/en-us/power-query/data-profiling-tools