What can you identify about the pickupLongitude column?

You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! 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.
B . All the table rows are profiled.
C . The column has missing values.
D . There are 935 values that occur only once.

View Answer

Answer: B

Explanation:

The pickupLongitude column has duplicate values. This can be inferred because the ‘Distinct count’ is 935 while the ‘Count’ is 1000, indicating that there are repeated values within the column.

Reference = Microsoft Power BI documentation on data profiling could provide further insights into understanding and interpreting column statistics like these.