PL-300 Question 12

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  * Answers: - There are [69] different values in State including nulls. - There are [4] non-null values that occur only once in State. Based on the profiling data from the exhibit: Distinct values: 69 Unique values (occur only once): 4 Nulls: 4% (but the question asks for distinct values including nulls, which is still 69 because null is counted as one distinct value in Power Query).

• 3

  69 and 4

• 1

  Different should include Distinct and Unique records