PrepAway - Latest Free Exam Questions & Answers

You need to produce the CSV file with the least amount of developmenteffort

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Create an Integration Services package and use a Fuzzy Lookup transform.

B.
Create a Master Data Services (MDS) model.

C.
Create a Data Quality Project.

D.
Create an Integration Services package and use a DQS Cleansing transform.

E.
Create an Integration Services package and use a Fuzzy Grouping transform.

One Comment on “You need to produce the CSV file with the least amount of developmenteffort


Leave a Reply