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 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.
Explanation:
The DQS Cleansing transformation uses Data Quality Services (DQS) to correct data from a
connected data source, by applying approved rules that were created for the connected data
source or a similar data source.
To determine whether the data has to be corrected, the DQS Cleansing transformation
processes data from an input column when the following conditions are true:
* The column is selected for data correction.
* The column data type is supported for data correction.
* The column is mapped a domain that has a compatible data type.
* The transformation also includes an error output that you configure to handle row-level
errors
I believe it should be C, Not a hundred procent on this but
a data quality project can export the results to SQL Server, Csv file and Excel file
C is the correct answer
C
Just a horrible question. Both C and D are equally good.
Best answer is C:
https://technet.microsoft.com/en-us/library/hh213052(v=sql.110).aspx
I Go With C. …
C is the best option as question mentioned “least amount of development effort”
C is my preferred answer too:
https://technet.microsoft.com/en-us/library/hh213055(v=sql.110)
Profiling Data in Activity Monitoring
Profiling information for the Knowledge Discovery, Matching Policy, Matching, and Cleansing activities is available not only in the activity pages in the Data Quality client, but also in activity monitoring. Activity monitoring provides you with an overview of current and past activities. In addition to the properties and related computational processes of activities, you can view the profiling information generated for each activity in one location. You select an activity in the activity table to display profiling results in a table below. You can also export the profiling results. For more information, see DQS Administration.