Analyzing Data with Microsoft Power BI (legacy) — Question 26

You need to review the data for which there are concerns before creating the data model.
What should you do in Power Query Editor?

Answer options

• 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

The correct answer is D because selecting Column profile provides detailed statistical insights about the sales_amount column, helping to identify any potential issues with the data. Options A, B, and C focus on specific modifications or broad distribution views, which do not offer the comprehensive analysis needed to address concerns before creating the data model.