You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. You need to use DQS profiling to obtain the required statistics. Which DQS activity sh

The correct answer is A. Cleansing. The DQS Cleansing activity is the only DQS activity that produces profiling statistics about the source data being processed. During cleansing, DQS evaluates each field against the knowledge base and surfaces metrics including completeness (how many values are populated), accurac

Build data quality solutions

Question

You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. You need to use DQS profiling to obtain the required statistics. Which DQS activity should you use?

Options

ACleansing
BMatching
CKnowledge Discovery
DMatching Policy

How the community answered

(22 responses)

A
91% (20)
C
5% (1)
D
5% (1)

Explanation

The DQS Cleansing activity is the only DQS activity that produces profiling statistics about the source data being processed. During cleansing, DQS evaluates each field against the knowledge base and surfaces metrics including completeness (how many values are populated), accuracy (how closely values match the knowledge base), consistency, and validity. These statistics directly satisfy the requirement for reporting on data accuracy. Knowledge Discovery (C) is used to build and enrich the knowledge base itself, not to profile source data. Matching (B) and Matching Policy (D) focus on identifying and configuring rules for duplicate detection, and do not generate accuracy profiling statistics on the input dataset.

Topics

#DQS profiling#cleansing activity#data accuracy statistics#data quality metrics

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice