CDP Data Quality Management 2

Question 1

What does 'data deduplication' specifically address?

Accepted Answer

Identifying and removing or merging duplicate records representing the same real-world entity

Answer

Data deduplication identifies records that represent the same entity (e.g., the same customer) and removes or merges them to create a single, accurate record.

Question 2

What is 'referential integrity' in relational databases?

Accepted Answer

A constraint ensuring that foreign key values in a child table match existing primary key values in the parent table

Answer

Referential integrity ensures that every foreign key value in a child table corresponds to an existing primary key value in the parent table, preventing orphaned records.

Question 3

Which technique uses statistical analysis to identify records that deviate significantly from expected patterns, indicating potential quality issues?

Accepted Answer

Outlier Detection / Anomaly Analysis

Answer

Outlier and anomaly detection uses statistical methods to identify data values or records that fall outside expected ranges, signaling potential quality issues.

Question 4

What is 'data standardization' in data quality management?

Accepted Answer

Converting data to a common format, structure, or value set to ensure consistency

Answer

Data standardization converts data to consistent formats, structures, and representations (e.g., date formats, address formats, abbreviation expansion) to enable accurate comparison and integration.

Question 5

What is the cost of poor data quality most directly associated with in business terms?

Accepted Answer

Flawed business decisions, wasted effort on rework, and lost revenue opportunities

Answer

Poor data quality leads to flawed business decisions, costly rework, regulatory fines, lost customers, and missed revenue opportunities.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Quality Management 2