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 3 question 94 discussion

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

HOTSPOT -

You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:

• The percentage of values that contain errors.
• The count of empty values.

What should you enable? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by 57fa092 at Jan. 14, 2025, 2:32 p.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
Pey1nkh
Highly Voted 3 months, 3 weeks ago
Error Percentage : Column quality Count of Zero : Column Profile (Zero Percentage : Column Quality)
upvoted 13 times
...
f133b89
Highly Voted 3 months, 2 weeks ago
Both Answers are Column Quality Column Quality: The Column quality feature in Power Query provides a visual summary of the column data, including: The percentage of valid values. The percentage of error values. The percentage of empty (null) values. This is exactly what you need to see both the percentage of errors and the count of empty values. Column Profile: The Column profile provides a statistical overview of the data, such as distinct values, unique values, and value distribution. While useful, it does not specifically display the percentage of errors or count of empty values. Column Distribution: The Column distribution feature shows the frequency distribution of values in the column as a bar chart. It is not used for viewing errors or empty values.
upvoted 6 times
...
be79ac3
Most Recent 3 weeks, 4 days ago
Quality - as it is a % Profile - as it counts
upvoted 1 times
...
Jasmine121
2 months, 3 weeks ago
They are Quality and Profile.
upvoted 1 times
...
Jasmine121
2 months, 3 weeks ago
quality/profile one for percentage, one for counts
upvoted 1 times
...
santhosh28
3 months, 2 weeks ago
Tested: Column Quality Column Profile
upvoted 5 times
...
57fa092
4 months ago
Both should be Column Quality
upvoted 2 times
57fa092
3 months, 3 weeks ago
after review, i think , column quality and column profile
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago