CDO Data Quality Management 2 — Questions and Answers
Question 1: What is the primary role of data stewards in a data quality program?
- Writing software code for data pipelines
- Owning and enforcing data quality standards for specific data domains (Correct answer)
- Managing the organization's cloud infrastructure
- Conducting external security audits
Correct answer: Owning and enforcing data quality standards for specific data domains
Data stewards are accountable for the quality, meaning, and appropriate use of data within their assigned domains, enforcing standards set by governance bodies.
Question 2: Which technique is used to identify data quality issues by analyzing patterns and anomalies in data without predefined rules?
- Manual data entry validation
- Schema enforcement
- Data profiling (Correct answer)
- Role-based access control
Correct answer: Data profiling
Data profiling analyzes existing data to discover patterns, anomalies, and statistical summaries, revealing quality issues before predefined business rules are applied.
Question 3: An organization's CRM stores phone numbers in inconsistent formats such as '555-1234', '(555)1234', and '5551234'. Which data quality dimension is primarily violated?
- Accuracy
- Consistency (Correct answer)
- Completeness
- Timeliness
Correct answer: Consistency
Consistency requires that data values follow the same format and representation across the dataset; varying formats for the same field directly violate this dimension.
Question 4: What is a data quality SLA (Service Level Agreement) used for in enterprise data management?
- Defining legal penalties for data breaches
- Establishing agreed-upon data quality targets between data producers and consumers (Correct answer)
- Setting performance benchmarks for server uptime
- Governing data sharing agreements with third-party vendors
Correct answer: Establishing agreed-upon data quality targets between data producers and consumers
A data quality SLA defines agreed-upon quality thresholds and metrics between data producers and consumers, establishing accountability and expectations for data delivery.
Question 5: Which concept tracks data from its origin through all transformations to its final use and supports root-cause analysis of quality issues?
- Data sovereignty
- Data ownership mapping
- Data lineage (Correct answer)
- Data archival policy
Correct answer: Data lineage
Data lineage documents the complete journey of data from its origin through all transformations and movements to its final destination, enabling quality issue root-cause analysis and impact assessment.
Question 6: A CDO implements automated checks in the ETL pipeline that isolate records failing validation before they reach the target system. What is this practice called?
- Data quarantine (Correct answer)
- Passive monitoring
- Data masking
- Batch reconciliation
Correct answer: Data quarantine
Data quarantine isolates records that fail quality validation rules, preventing bad data from entering the target system while flagging isolated records for review and remediation.
Question 7: Which framework is most commonly referenced by CDOs for establishing enterprise data quality standards and best practices?
- ITIL (IT Infrastructure Library)
- DAMA-DMBOK (Data Management Body of Knowledge) (Correct answer)
- PMBOK (Project Management Body of Knowledge)
- COBIT (Control Objectives for IT)
Correct answer: DAMA-DMBOK (Data Management Body of Knowledge)
DAMA-DMBOK is the definitive framework for data management professionals, providing comprehensive guidance on data quality management practices, standards, and processes.
CDO Data Quality Management 2
What is the primary role of data stewards in a data quality program?