ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 12 discussion

Actual exam question from Microsoft's PL-300
Question #: 12
Topic #: 1
[All PL-300 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
olajor
Highly Voted 2 years, 7 months ago
69 is always the right choice! ;)
upvoted 146 times
loganzz
8 months, 4 weeks ago
69 and 4
upvoted 8 times
...
yaguitoEC
1 year, 9 months ago
Yes, best answer
upvoted 5 times
...
...
learnazureportal
Highly Voted 2 years, 7 months ago
Answer is correct
upvoted 28 times
...
BP215
Most Recent 3 days, 11 hours ago
69 and 4
upvoted 1 times
...
pavanmanideep
2 months, 2 weeks ago
Different should include Distinct and Unique records
upvoted 1 times
...
ddd29291998
7 months, 2 weeks ago
Actually, I tested and "unique" also counts a unique blank cell if you have it
upvoted 2 times
...
rcaliandro
8 months, 3 weeks 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
8 months, 3 weeks ago
69 and 4 is the correct option:
upvoted 1 times
...
CaptainSappy11
1 year ago
Answer is correct.
upvoted 2 times
...
sm222
1 year, 1 month 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, 2 months ago
Answer is correct
upvoted 1 times
...
TrustMyAnswers
1 year, 5 months ago
Given answers are correct. 69 distinct, 4 unique.
upvoted 6 times
...
thomas_90
1 year, 7 months ago
69 and 4
upvoted 4 times
...
SaiCharan534
1 year, 7 months ago
69 , 4 : )
upvoted 2 times
...
Igetmyrole
1 year, 8 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, 8 months ago
69 and 4
upvoted 3 times
...
madyjoe21
1 year, 9 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, 8 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
Xtophine
1 year, 7 months ago
Nice explanation!!!
upvoted 1 times
...
powerbot9000
1 year, 3 months ago
Perfect explanation, but correct me if I am wrong this data set would then have 65 null values?
upvoted 1 times
...
...
mustafaalhnuty
1 year, 8 months ago
every unique value is considered as distinct so sum with distinct my friend :)
upvoted 1 times
...
...
ET_phone_home_son
1 year, 10 months ago
69 DIstinct (DIfferent) values (including null) / 4 UNIque (1 (UNI) appearance each) values
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago