You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL
Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been
created to support this project. You need to produce the CSV file with the least amount of developmenteffort.
What should you do?
A.
Create an Integration Services package and use a Data Profiling transform.
B.
Create a custom .NET application based on the Knowledgebase class.
C.
Create a CLR stored procedure based on the Knowledgebase class.
D.
Create a Master Data Services (MDS) business rule.
E.
Create a data quality project.
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/hh213052.aspx
http://msdn.microsoft.com/en-us/library/ff877917.aspx
http://msdn.microsoft.com/en-us/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.
aspx
http://msdn.microsoft.com/en-us/library/bb895263.aspx