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

Encrypting duplicate copies of data for security

Answer

Creating backup copies of critical data

Answer

Compressing redundant data blocks in storage systems

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

A backup strategy for critical reference data

Answer

A method for encrypting primary key values

Answer

A normalization rule for third normal form

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

Data Masking

Answer

Data Standardization

Answer

Record Linkage

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

Creating documentation standards for data assets

Answer

Selecting a single DBMS vendor for the organization

Answer

Defining the minimum acceptable quality thresholds for data

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

Higher database licensing fees

Answer

Increased storage costs

Answer

Slower database query performance

Question 6

Which data quality practice involves monitoring data quality metrics continuously and alerting stakeholders when thresholds are breached?

Accepted Answer

Data Quality Monitoring / Alerting

Answer

Data Profiling

Answer

Data Cleansing

Answer

Data Auditing