CDS Data Quality Management 3

Question 1

Which of the following best describes 'data profiling' in a data quality context?

Accepted Answer

Analyzing data to understand its structure, content, and quality characteristics

Answer

Data profiling examines datasets to discover metadata, patterns, anomalies, and quality issues such as nulls, duplicates, and format inconsistencies.

Question 2

When implementing a 'right-first-time' data quality strategy, what is the primary focus?

Accepted Answer

Preventing defects at the point of data entry or creation

Answer

Right-first-time focuses on defect prevention at the source rather than downstream correction, reducing the cost of poor data quality.

Question 3

A data quality rule flags all ZIP codes that do not match the U.S. five-digit or ZIP+4 format. This is an example of which type of rule?

Accepted Answer

Format/pattern rule

Answer

Format (or pattern) rules validate that data values conform to a specific syntactic structure, such as a regular expression for ZIP codes.

Question 4

What is the COST OF POOR DATA QUALITY (CPDQ) model primarily used for?

Accepted Answer

Quantifying the financial impact of data defects to justify DQ investments

Answer

The CPDQ model quantifies costs such as rework, failed decisions, compliance fines, and lost revenue to build a business case for data quality programs.

Question 5

Which data quality technique involves comparing data against a trusted external reference source to verify accuracy?

Accepted Answer

Data reconciliation with a golden record

Answer

Reconciling data against a golden record or authoritative external source validates that internal data accurately reflects the real-world values it represents.

(CDS) Certified Data Steward Practice Test

(CDS) Certified Data Steward Practice Test

CDS Data Quality Management 3