You need to produce the CSV file with the least amount of development effort

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 development effort. What should you do?

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 development effort. 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 data quality project.

D.
Create a CLR stored procedure based on the Knowledgebase class.

E.
Create a Master Data Services (MDS) business rule.

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/hh213052.aspx
http://msdn.microsoft.com/en-us/library/ff877917.aspx
http://msdn.microsoft.com/enus/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.aspx
http://msdn.microsoft.com/en-us/library/bb895263.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *