Exam DA-100 topic 6 question 2 discussion

D because it has a min and a max info so you can see if there are negative values.

The correct answer is A. Transform the sales_amount column to replace negative values with 0. As per the question, you are concerned with the quality and completeness of the sales data, particularly with negative sales amounts. In such a case, in Power Query Editor, you should transform the sales_amount column to replace all negative values with 0. This can be done by selecting the sales_amount column, right-clicking on it, and selecting "Replace Values". In the dialog box that appears, you can replace all negative values with 0. Selecting Column distribution and Column profile will provide you with an overview of the data distribution and profile of the sales_amount column, respectively, but it won't address the specific concern related to negative sales amounts. Selecting the sales_amount column and applying a number filter will help you filter the data based on sales amounts, but again, it doesn't address the specific concern about negative sales amounts

Select Column profile, and then select the sales_amount column for review the data

D is the answer, first review and then you do A

It's definiely D, because it says that you have to "review" not what do after reviewing.

why so little dicussion?

D is the correct answer