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

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

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.

by INDEAVR at Oct. 13, 2022, 5:23 a.m.

Comments

Submit Cancel

INDEAVR

Highly Voted 2 years, 9 months ago

answer is correct

upvoted 47 times

...

Mati_123

Highly Voted 2 years, 4 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 44 times

1CY1

10 months, 2 weeks 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 8 months, 2 weeks 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

11 months, 2 weeks ago

The answer is correct. There are 20 unique values and the specie is Elm American

upvoted 1 times

...

Inesd

1 year, 2 months 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

1 year, 4 months ago

28-Mar-24 - This Q came up

upvoted 4 times

...

cs3122

1 year, 6 months ago

provided answer is correct

upvoted 2 times

...

LeeTheRed

1 year, 7 months ago

This Question was in the exam today 9/12/2023

upvoted 5 times

Diogo1998

1 year, 7 months ago

How many question in this site was on your exam?

upvoted 1 times

...

SamuComqi

2 years ago

I passed the exam today (948/1000). My answer was: - are 20 values that occur - Elm, American

upvoted 10 times

...

sdaaram

2 years ago

This was on exam yesterday

upvoted 5 times

...

MoxieTT

2 years ago

This was in the exam

upvoted 3 times

...

Shalaleh

2 years, 3 months ago

Given answer is correct.

upvoted 1 times

...

youssef_yt89

2 years, 5 months ago

how about the second answer, that s clear that the answer is ash

upvoted 1 times

...

Jejemon

2 years, 7 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

2 years, 7 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

2 years, 8 months ago

Correct

upvoted 2 times

...

lukelin08

2 years, 8 months ago

Given answer is correct 100%

upvoted 2 times

...

Load full discussion...