Exam DP-600 topic 1 question 19 discussion

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)

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.

The column has duplicate values.

The column has duplicate values

Answer A: Distinct Value: This refers to all different values present in a dataset. When you retrieve distinct values from a column, you eliminate duplicate values so that each value is shown once. For example, if a column contains the values [1, 2, 2, 3, 3, 3], the distinct values would be [1, 2, 3]. Unique Value: This usually refers to values that appear only once in the dataset. Unlike distinct values, a unique value will only be considered if it has no duplicates at all. For example, if a column contains the values [1, 2, 2, 3, 3, 3], the unique values would be [1], since only 1 appears without repetition.

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.

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.

A is Best choice based on the picture.

Its A Only one column selected here No informations about missing values Distinct count not mean exist only once