Implementing a SQL Data Warehouse — Question 71

You are managing the domain for a knowledge base.
The table named Table1 is mapped to a single domain named Domain1.
New distinct values have appeared in Table1. Some of the values are the result of data entry errors. You need to update the knowledge base with the new values and exclude data entry errors.
You need to add the new knowledge base information and retain the corrections made within the knowledge base.
What should you do?

Answer options

• A. Create a new data quality project for data cleansing. Export the cleansing results to a new table in the database, using output format Data Only.
• B. Perform domain management on Domain1. Use the Domain Values tab to add a new domain value for each new distinct value in Table1.
• C. Perform knowledge discovery. Map Domain1 to Table1. Use the Manage Domain Values tab to evaluate new distinct values.
• D. Create a new data quality project for data cleansing. Export the cleansing results to a new table in the database, using output format Data and Cleansing Info.

Correct answer: A

Explanation

The correct answer is A because creating a new data quality project for data cleansing allows for the identification and removal of incorrect values while keeping the valid ones. The other options do not effectively address the need to cleanse the data and maintain corrections, as they either add new values without validation (B) or perform evaluations without correcting the errors (C), or export unnecessary cleansing information (D).