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.
Error Percentage : Column quality Count of Zero : Column Profile (Zero Percentage : Column Quality)
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.
Tested: Column Quality Column Profile
Both should be Column Quality
after review, i think , column quality and column profile
quality/profile one for percentage, one for counts
They are Quality and Profile.
Quality - as it is a % Profile - as it counts