Home » Microsoft » DA-100 » You need to review the data for which there are concerns before creating the data model.
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: A
Explanation/Reference:
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.
How to convert negative numbers into positive numb, editor and right click, select transform, and choose absolute value. That would give the positive number outcome you’re looking for.
Reference:
https://www.xspdf.com/resolution/50510644.html02 – Prepare the Data