Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 12 discussion

Actual exam question from Microsoft's PL-300

Question #: 12
Topic #: 1

HOTSPOT -
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: 69 -
69 distinct/different values.
Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column).

Box 2: 4 -
Reference:
https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/

by learnazureportal at Sept. 13, 2022, 1:48 a.m.

Comments

Submit Cancel

olajor

Highly Voted 2 years, 9 months ago

69 is always the right choice! ;)

upvoted 146 times

loganzz

10 months, 1 week ago

69 and 4

upvoted 9 times

...

yaguitoEC

1 year, 11 months ago

Yes, best answer

upvoted 5 times

...

learnazureportal

Highly Voted 2 years, 9 months ago

Answer is correct

upvoted 28 times

...

BP215

Most Recent 1 month, 2 weeks ago

69 and 4

upvoted 2 times

...

pavanmanideep

4 months ago

Different should include Distinct and Unique records

upvoted 1 times

...

ddd29291998

9 months ago

Actually, I tested and "unique" also counts a unique blank cell if you have it

upvoted 3 times

...

rcaliandro

10 months, 1 week ago

69 and 4 is the correct option: There are 69 different values in State including nulls There are 4 non-null values that occur only once in State

upvoted 3 times

...

rcaliandro

10 months, 1 week ago

69 and 4 is the correct option:

upvoted 1 times

...

CaptainSappy11

1 year, 1 month ago

Answer is correct.

upvoted 2 times

...

sm222

1 year, 2 months ago

For everyone confused, the rule to remember is that Unique values are a subset of distinct values. So, every unique value is a distinct value but distinct values are not always unique.

upvoted 18 times

...

shulaijia

1 year, 3 months ago

Answer is correct

upvoted 1 times

...

TrustMyAnswers

1 year, 7 months ago

Given answers are correct. 69 distinct, 4 unique.

upvoted 6 times

...

thomas_90

1 year, 8 months ago

69 and 4

upvoted 4 times

...

SaiCharan534

1 year, 9 months ago

69 , 4 : )

upvoted 2 times

...

Igetmyrole

1 year, 9 months ago

69 and 4 are correct. The column has 69 distinct values, which includes all unique values (4) plus the empty values(nulls). There are 4 unique values in the column, those are non-null values that occur only once in the "State" column.

upvoted 9 times

...

n_uttam28

1 year, 10 months ago

69 and 4

upvoted 3 times

...

madyjoe21

1 year, 10 months ago

Why the 4 unique values are not considered district values as well? I didn't get it! Does anyone could help me please? Ty. Answer: 73 and 4

upvoted 1 times

Bamlaku

1 year, 10 months ago

This Column Distribution feature allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column). In other words, distinct values represent the total number of different values found in a given column, while unique values represent the total number of values that only appear once in a given column. Cheers!

upvoted 11 times