Home » Microsoft » DA-100 v.2 » What should you do in Power Query Editor?
You need to review the data for which there are concerns before creating the data model.
What should you do in Power Query Editor?
A. Transform the sales_amount column to replace negative values with 0.
B. Select Column distribution.
C. Select the sales_amount column and apply a number filter.
D. Select Column profile, and then select the sales_amount column.
Correct Answer: D
Explanation/Reference:
Explanation:
Scenario: Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
The Column profile feature provides a more in-depth look at the data in a column. It contains a column statistics chart that displays Count, Error, Empty, Distinct, Unique, Empty String, Min, & Max of the selected column.
Reference:
https://docs.microsoft.com/en-us/power-query/data-profiling-tools
https://powerbidocs.com/2021/03/02/column-quality-column-distribution-column-profile/