Answer-first summary for fast verification
Answer: The column has duplicate values.
The exhibit indicates that for the pickupLongitude column, the count of values is 1,000, while the distinct count is 871. This means there are 1,000 total values with only 871 being distinct, implying that some values are duplicated. Additionally, the information shows no missing values and only a subset of the total 2,000 rows (specifically 1,000) is profiled. Therefore, the correct identification is that the column has duplicate values.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a Fabric workspace named Workspace1 that houses a dataflow named Dataflow1. Within Dataflow1, there is a query returning 2,000 rows. In Power Query, you examine the query, as illustrated in the following exhibit. The exhibit provides column statistics for the pickupLongitude column, revealing a count of 1,000, a distinct count of 871, and no missing values in the sample. What conclusions can you draw 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.