Microsoft
70-463 · Question #55
70-463 Question #55: Real Exam Question with Answer & Explanation
The correct answer is C. Create a Data Quality Project.. us/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.aspx
Build data quality solutions
Question
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?
Options
- ACreate an Integration Services package and use a Fuzzy Lookup transform.
- BCreate a Master Data Services (MDS) model.
- CCreate a Data Quality Project.
- DCreate an Integration Services package and use a DQS Cleansing transform.
- ECreate an Integration Services package and use a Fuzzy Grouping transform.
Explanation
us/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.aspx
Topics
#Data Quality Services#duplicate detection#DQS knowledge base#data quality project
Community Discussion
No community discussion yet for this question.