CompTIA Data+ (DA0-002)Data Governance, Quality and ControlsEasy
A data analyst reviews a customer table and finds that every phone number field contains exactly 10 digits with no letters or special characters, matching the required format for that field. Which data quality dimension does this satisfy?
- ACompleteness
- BValidity
- CTimeliness
- DUniqueness
Show answer & explanationAnswer & explanation
Correct answer: B. Validity
Validity measures whether data conforms to a defined format, type, or range of acceptable values. Since the phone numbers match the required 10-digit format, this is a validity check, not completeness (missing values) or uniqueness (duplicates).
Why the other options are wrong
- A. Completeness measures whether required data is present, not whether the format is correct.
- C. Timeliness measures how current the data is, not its format.
- D. Uniqueness measures whether duplicate records exist, not format compliance.
Validity (Data Quality Dimension)
The degree to which data conforms to the syntax, format, type, or range defined by business or system rules.
- Checks format, type, and allowable range
- Different from accuracy (validity can be correct format but wrong fact)
- Commonly enforced via validation rules or constraints
Memory trick: 'A CUTV' car: Accuracy, Completeness, Uniqueness, Timeliness, Validity