Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 25 discussion

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

HOTSPOT -
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are 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: are 20 values that occur -
There are 20 unique values.

Box 2: Elm, American -
Elm, American is below Peer, flowering species in the graphic.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
INDEAVR
Highly Voted 2 years, 1 month ago
answer is correct
upvoted 45 times
...
Mati_123
Highly Voted 1 year, 8 months ago
Answer to unique count is correct. Let me make it more clear for you guys: Example: 1, 2 ,2 4,4 5,5,6 Distinct number are = 5 which are 1,2,4,5,6 Unique Numbers are = 2 which is1 and 6... as these numbers appeared only once
upvoted 40 times
1CY1
2 months, 1 week ago
The words used in the drop down are 'values that occur' not 'unique values that occur' -> unclear wording???
upvoted 1 times
...
...
jaume
Most Recent 4 days, 13 hours ago
"are 20 values that occur" is the first answer; unique values are the ones coccurring only once "Elm, America" is the specie reported in the bar chart below the "Pear, Flowering" so it's the only one occurring less times
upvoted 1 times
...
rcaliandro
3 months, 1 week ago
The answer is correct. There are 20 unique values and the specie is Elm American
upvoted 1 times
...
Inesd
5 months, 4 weeks ago
I do not see the link between the word occur(rence) and unique? could someone explain? because when we talk about occurrence it could about distinct values also
upvoted 1 times
...
b7c21a9
8 months ago
28-Mar-24 - This Q came up
upvoted 4 times
...
cs3122
10 months ago
provided answer is correct
upvoted 2 times
...
LeeTheRed
11 months, 3 weeks ago
This Question was in the exam today 9/12/2023
upvoted 5 times
Diogo1998
11 months, 2 weeks ago
How many question in this site was on your exam?
upvoted 1 times
...
...
SamuComqi
1 year, 4 months ago
I passed the exam today (948/1000). My answer was: - are 20 values that occur - Elm, American
upvoted 10 times
...
sdaaram
1 year, 4 months ago
This was on exam yesterday
upvoted 5 times
...
MoxieTT
1 year, 4 months ago
This was in the exam
upvoted 3 times
...
Shalaleh
1 year, 6 months ago
Given answer is correct.
upvoted 1 times
...
youssef_yt89
1 year, 9 months ago
how about the second answer, that s clear that the answer is ash
upvoted 1 times
...
Jejemon
1 year, 11 months ago
Answer to unique count is correct. E.g. 1 2 3 4 5 6 1 2 3 4 5 1 number is unique which is 6 - appeared only ONCE 6 numbers are distinct - 6 unique numbers
upvoted 5 times
...
csillag
1 year, 11 months ago
“Distinct” means number of different values regardless how many times it appears in the dataset. A 'name' appears in the list multiple times is counted as 1 distinct count. Whereas, the “Unique” value is total number of values that only appear once.  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 So the answer is correct.
upvoted 2 times
...
Rickson
1 year, 11 months ago
Correct
upvoted 2 times
...
lukelin08
1 year, 12 months ago
Given answer is correct 100%
upvoted 2 times
...
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
Loading ...