On your first day at MDFT Pro, a well-known training agency, you are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.
| Metric | Value |
|---|---|
| Valid | 96% |
| Error | 0% |
| Empty | 4% |
| Distinct | 69 |
| Unique | 4 |
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
73 is incorrect. The value 73 does not match the Unique count of 4 shown in the exhibit for non-null values occurring once.
69 is incorrect. The value 69 is the distinct count, not the unique count.
4 is correct. The Unique metric shows 4, which represents the number of non-null values that occur exactly once in the State column.
65 is incorrect. The value 65 does not match the Unique count of 4 shown in the exhibit for non-null values occurring once.
73 is incorrect. The value 73 is not supported by any metric in the exhibit.
4 is incorrect. The value 4 is the unique count, not the distinct count.
65 is incorrect. The value 65 does not correspond to the distinct or unique counts displayed in the exhibit.
69 is correct. The Distinct metric shows 69, which represents the number of different values in the State column including nulls. This is exactly what the statement asks for.