Analyzing and Visualizing Data with Microsoft Power BI — Question 124

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerID column are set to 0.
Solution: From Query Editor, select the CustomerID column and click Replace Values....
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The solution does not meet the goal because using Replace Values without specifying a condition for nonnumeric values will not convert them to 0. Instead, it will only replace existing values with other specified values. Therefore, the correct answer is B, as the proposed solution is ineffective in addressing the issue of nonnumeric entries in the CustomerID column.