exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 72 discussion

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

HOTSPOT
-

You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution 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.

Show Suggested Answer Hide Answer
Suggested Answer:

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
Mohammedahe
Highly Voted 1 year, 11 months ago
Correct!
upvoted 17 times
...
pverde
Highly Voted 2 years ago
Correct
upvoted 9 times
...
jaume
Most Recent 8 months, 3 weeks ago
Agree with 45 as the most frequent value and 24 with the minimum value as stated in the left pane....and suprised with the Max being 1431!!! It's currently not shown in the columns chart but it's mentioned below the min for 24... since the column is named Max Temp, it looks like this is really the max Temp!!!
upvoted 1 times
...
ChopChop007
10 months, 3 weeks ago
Correct!
upvoted 1 times
...
rcaliandro
11 months, 4 weeks ago
Correct answer
upvoted 1 times
...
paulus100
1 year, 6 months ago
Correct
upvoted 2 times
...
Enrique67
1 year, 7 months ago
Perdon pero no entiendo porque 0 no es una temperatura y ademas es no nulo
upvoted 1 times
Enrique67
1 year, 7 months ago
Perdon, 0 seria valido pero claramente pone en las estadisticas que el minimo es 24. No dije nada
upvoted 1 times
...
...
Nagasoracle
1 year, 7 months ago
Plz Any one explain this question.
upvoted 2 times
KauK
1 year, 7 months ago
The first question is asking which value was repeated the most in the column, as in, frequency. When the frequency of the value increases, the bar shown in "value distribution" also increases. So the biggest bar is of the value that is repeated the most, which is 45. For the second question, the smallest NON-null value, is a fancy way of saying the minimum value that is actually a value not an error, null or an empty field. Which is shown on the left hand side as 24. This view is Column Profiling it profiles just one column and brings a lot of statistics about it as you can see. You can read more here. https://learn.microsoft.com/en-us/power-query/data-profiling-tools
upvoted 14 times
Inesd
1 year, 2 months ago
Thank you for the explanation
upvoted 1 times
...
MoneyStacking
1 year, 3 months ago
Correct, cannot be better explained than this!
upvoted 1 times
...
...
...
lmrod
1 year, 11 months ago
Absolutely correct
upvoted 5 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 ...