Microsoft
70-463 · Question #114
70-463 Question #114: Real Exam Question with Answer & Explanation
The correct answer is A: It enables you to perform data cleansing on your source data by using the knowledge in a. DQS data quality projects provide two core benefits: data cleansing using knowledge base domain knowledge, and data matching using the matching policy defined within a DQS knowledge base.
Question
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing data quality projects. Which of the following are benefits of data quality projects? (Choose all that apply.)
Options
- AIt enables you to perform data cleansing on your source data by using the knowledge in a
- BIt allows you to perform data matching on your source data by using the knowledge in a DQS
- CIt allows you to perform data matching on your source data by using the matching policy in a
- DIt enables you to perform data cleansing on your source data by using the matching policy in
Explanation
DQS data quality projects provide two core benefits: data cleansing using knowledge base domain knowledge, and data matching using the matching policy defined within a DQS knowledge base.
Common mistakes.
- B. Data matching is performed using the matching policy specifically, not general 'knowledge in a DQS knowledge base'; the matching policy is a distinct component from the cleansing knowledge used in domain management.
- D. Data cleansing uses domain rules and cleansing knowledge defined in the knowledge base, not the matching policy, which is a separate component designed exclusively for deduplication.
Concept tested. DQS data quality project cleansing and matching policy benefits
Reference. https://learn.microsoft.com/en-us/sql/data-quality-services/data-quality-projects-dqs
Community Discussion
No community discussion yet for this question.