Implementing a SQL Data Warehouse — Question 32
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 Microsoft SQL server that has Data Quality Services (DQS) installed.
You need to review the completeness and the uniqueness of the data stored in the matching policy.
Solution: You create a matching rule.
Does this meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
Creating a matching rule does not directly address the assessment of data completeness and uniqueness; it primarily focuses on how records are matched. To evaluate completeness and uniqueness, you would need to use data profiling tools or techniques that specifically analyze data quality aspects.