CDP Data Quality Management 2 — Questions and Answers
Question 1: What does 'data deduplication' specifically address?
- Encrypting duplicate copies of data for security
- Identifying and removing or merging duplicate records representing the same real-world entity (Correct answer)
- Creating backup copies of critical data
- Compressing redundant data blocks in storage systems
Correct answer: Identifying and removing or merging duplicate records representing the same real-world entity
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?
- A constraint ensuring that foreign key values in a child table match existing primary key values in the parent table (Correct answer)
- A backup strategy for critical reference data
- A method for encrypting primary key values
- A normalization rule for third normal form
Correct answer: A constraint ensuring that foreign key values in a child table match existing primary key values in the parent table
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?
- Data Masking
- Outlier Detection / Anomaly Analysis (Correct answer)
- Data Standardization
- Record Linkage
Correct answer: Outlier Detection / Anomaly Analysis
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?
- Converting data to a common format, structure, or value set to ensure consistency (Correct answer)
- Creating documentation standards for data assets
- Selecting a single DBMS vendor for the organization
- Defining the minimum acceptable quality thresholds for data
Correct answer: Converting data to a common format, structure, or value set to ensure consistency
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?
- Higher database licensing fees
- Increased storage costs
- Flawed business decisions, wasted effort on rework, and lost revenue opportunities (Correct answer)
- Slower database query performance
Correct answer: Flawed business decisions, wasted effort on rework, and lost revenue opportunities
Poor data quality leads to flawed business decisions, costly rework, regulatory fines, lost customers, and missed revenue opportunities.
Question 6: Which data quality practice involves monitoring data quality metrics continuously and alerting stakeholders when thresholds are breached?
- Data Profiling
- Data Cleansing
- Data Quality Monitoring / Alerting (Correct answer)
- Data Auditing
Correct answer: Data Quality Monitoring / Alerting
Data quality monitoring continuously tracks quality metrics against defined thresholds and triggers alerts when data quality degrades below acceptable levels.
CDP Data Quality Management 2
What does 'data deduplication' specifically address?