Exam PL-300 topic 3 question 94 discussion

Actual exam question from Microsoft's PL-300

Question #: 94
Topic #: 3

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

Suggested Answer:

by 57fa092 at Jan. 14, 2025, 2:32 p.m.

Comments

Submit Cancel

Pey1nkh

Highly Voted 5 months, 2 weeks ago

Error Percentage : Column quality Count of Zero : Column Profile (Zero Percentage : Column Quality)

upvoted 15 times

...

f133b89

Highly Voted 5 months, 1 week 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 7 times

...

Zakzouk23

Most Recent 1 month, 2 weeks ago

chatGPT : The correct answer is Column quality because it shows a visual summary of the column’s data, including the percentage of valid, error, and empty values. Although it primarily displays percentages, when you hover over the empty or error segments, a tooltip appears showing both the percentage and the actual count of values. Therefore, Column quality allows you to view both the percentage of values with errors and the count of empty values.

upvoted 1 times

...