CDS Data Quality Management 2 — Questions and Answers
Question 1: Which data quality dimension measures the degree to which data values fall within acceptable ranges or conform to defined domain rules?
- Completeness
- Validity (Correct answer)
- Timeliness
- Uniqueness
Correct answer: Validity
Validity measures whether data values conform to defined business rules, formats, or acceptable value domains.
Question 2: A data steward discovers that the same customer appears 47 times in the CRM with slight name variations. Which remediation technique best addresses this?
- Data masking
- Entity resolution / record linkage (Correct answer)
- Data tokenization
- Schema normalization
Correct answer: Entity resolution / record linkage
Entity resolution (record linkage) identifies and merges records that refer to the same real-world entity, resolving duplicate customer records.
Question 3: What is the primary purpose of a data quality scorecard?
- To document data lineage from source to target
- To track and communicate data quality KPIs over time (Correct answer)
- To define data ownership and stewardship roles
- To enforce referential integrity in the database
Correct answer: To track and communicate data quality KPIs over time
A data quality scorecard aggregates KPIs across dimensions and time periods to give stakeholders a repeatable view of quality health.
Question 4: In the context of data quality, what does 'fitness for purpose' mean?
- Data meets ISO 8000 international standards
- Data satisfies the specific needs of the intended use case (Correct answer)
- Data has passed all automated validation rules
- Data is stored in the correct physical format
Correct answer: Data satisfies the specific needs of the intended use case
Fitness for purpose means data quality is judged relative to whether the data adequately supports the specific decisions or processes it is intended for.
Question 5: Which technique uses statistical process control (SPC) charts to monitor data quality metrics over time?
- Data profiling
- Control charting (Correct answer)
- Root cause analysis
- Data cleansing
Correct answer: Control charting
Control charts (SPC charts) plot quality metrics over time with upper/lower control limits to detect abnormal variation early.
Question 6: A business rule states that every order must have a corresponding customer record. Which data quality dimension is violated when orphan orders exist?
- Accuracy
- Consistency
- Integrity (Correct answer)
- Timeliness
Correct answer: Integrity
Referential integrity violations — where child records exist without a valid parent — represent a failure of the Integrity dimension.
Question 7: What is the role of a 'data quality issue log' in an ongoing DQ program?
- It replaces the need for automated data profiling tools
- It tracks identified issues, root causes, owners, and remediation status (Correct answer)
- It stores all rejected records from ETL pipelines permanently
- It defines the business glossary and data definitions
Correct answer: It tracks identified issues, root causes, owners, and remediation status
A data quality issue log is a governance artifact that records detected problems along with their severity, ownership, remediation actions, and resolution status.
CDS Data Quality Management 2
Which data quality dimension measures the degree to which data values fall within acceptable ranges or conform to defined domain rules?