CompTIA Data+ (DA0-002)Data Governance, Quality and ControlsEasy
A data analyst reviews a customer database and finds that 15% of records have a blank value in the required 'State' field, which is needed for regional sales reporting. Which data quality dimension is being violated?
- ACompleteness
- BAccuracy
- CTimeliness
- DValidity
Show answer & explanationAnswer & explanation
Correct answer: A. Completeness
Completeness measures whether all required data values are present. Missing values in a mandatory field is a completeness problem, not accuracy (wrong values), timeliness (outdated values), or validity (values outside allowed format/range).
Why the other options are wrong
- B. Accuracy concerns whether existing values are correct, not whether they are present.
- C. Timeliness concerns how current the data is, not missing fields.
- D. Validity concerns whether values conform to defined formats or rules.
Completeness (Data Quality Dimension)
The degree to which all required data values are present in a dataset, with no missing mandatory fields.
- Measured as % of populated required fields vs total expected
- Missing/null values in mandatory fields reduce completeness
- Different from accuracy, which measures correctness of present values
Memory trick: 'CACTUS' - Completeness, Accuracy, Consistency, Timeliness, Uniqueness, Validity Standards