Question 2
You need to review the data for which there are concerns before creating the data model.
What should you do in Power Query Editor?
Transform the sales_amount column to replace negative values with0.
Select Columndistribution.
Select the sales_amount column and apply a numberfilter.
Select Column profile, and then select the sales_amountcolumn.
Correct answer: D
Explanation:
Confirm 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-toolshttps://powerbidocs.com/2021/03/02/column-quality-column-distribution-column-profile/
Confirm
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-
toolshttps://powerbidocs.com/2021/03/02/column-quality-column-distribution-column-profile/