Exam 70-767 topic 2 question 12 discussion

Actual exam question from Microsoft's 70-767

Question #: 12
Topic #: 2

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://docs.microsoft.com/en-us/sql/data-quality-services/cleanse-data-using-dqs-internal-knowledge?view=sql-server-ver15

by mickeymouse1234 at Nov. 17, 2020, 9:15 a.m.

Comments

Submit Cancel

mickeymouse1234

4 years, 5 months ago

If you need to "retain the corrections made within the knowledge base", shouldn't the correct answer be D?

upvoted 1 times

Lukis92

4 years, 5 months ago

"retain the corrections made within the knowledge base." - not in the exported table. I would rather choose C.

upvoted 2 times

...

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam

Exam 70-767 topic 2 question 12 discussion

Comments

mickeymouse1234

Lukis92

SY0-701