Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contain 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 mil not appear in the review screen.

You have a query for a table named Sales Sales has a column Named Customer lD. The Data Type of Customer ID 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 CustomerlD column are set to 0.

Solution: From Query Editor, select the CustomerID column and click Replace Values…

Does this meet the goal?
A . Yes
B . No

View Answer

Answer: B