In a Dataflows Query Editor, which option would you select to view the frequency of values and identify duplicates by count per value?

• A. Column profile - values count
• B. Column distribution - distinct values
• C. Column distribution - unique values
• D. Column quality - valid values

Answer: (A)

Viewing how often each value appears in a column is a form of profiling the data. When you use the column profile and request the values count, you get a per-value tally that shows exactly how many times every value occurs. This makes duplicates visible by their higher counts and lets you quantify frequency across the data.

The reason this is the best choice is that it directly reports the count of occurrences for each distinct value, which is what you need to identify duplicates by how often they appear. Other options focus on the spread or distribution of values (how many distinct values exist or how values are spread) or on data quality (whether values are valid), but they don’t provide the per-value frequency counts you’re looking for. For example, distribution views may show distinct or unique values but not how many times each one occurs, and quality checks don’t address frequency at all.

So, choose the column profile with values count to see the frequency per value and spot duplicates by their counts.