Question
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows.
You view the query in Power Query as shown in the following exhibit.
What can you identify about the pickupLongitude column?
- A. The column has duplicate values. Correct
- B. All the table rows are profiled.
- C. The column has missing values.
- D. There are 935 values that occur only once.
Explanation
The column statistics show a Count of 1000 but a Distinct count of 935 and a Unique count of 871, so some values appear more than once and the column has duplicates. Only 1,000 of the query's 2,000 rows were profiled, because column profiling is based on the top 1,000 rows by default, so not all rows are profiled. Null count, Error count and NaN count are all 0, so there are no missing values. Values that occur only once are the Unique count (871), not the Distinct count (935).
