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?
From the column statistics displayed in the Power Query interface, it is evident that the 'pickupLongitude' column has a total count of 1000 and a distinct count of 935, which indicates that there are duplicate values in the column. This means some values in 'pickupLongitude' are repeated.
Answer A. B - Not all the rows are profiled in the sample (only 1000 of 2000) C- From the column statistics, you don't have any missing values in the sample D- The values that occur only once are 871 (unique count)
correct
A We see a count of 1000 (which is the limit by default) we do not know all the data is read, but we can see of the 1000 distinct is less and so we have duplicate values.
Its A Only one column selected here No informations about missing values Distinct count not mean exist only once
Answer is A Distinct mean : count all the values as 1, even if there was more than one. Unique mean : count only the value that are not repeated in the particular column
IMHO, it is A, well explained below
A my reasoning: every other answer option cannot be answered for sure since only 1000 values out of 2000 are profiled. -> B: only 1000 rows are profiled -> C: the column might have missings -> D: there might be more unique/distinct counts.
Difficult to say if BCD are correct since we only see 1000 rows and not all columns. One thing is for sure though, there are columns that have values that occur more than once.
A is Best choice based on the picture.