Data Quality & Validation Flashcards
7 cards from real ADC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Quality & Validation flashcards as text
Cross-field validation checks which of the following?
Answer: That the relationship between two or more fields within a record is logically correct
Cross-field validation ensures that the combination of values across multiple fields is logically consistent, such as verifying that an end date is always after a start date.
Which metric is used to express the percentage of records that contain all required fields with valid values?
Answer: Completeness rate
The completeness rate is calculated as the ratio of records with all required fields populated to the total number of records, expressed as a percentage.
In data quality management, what is a 'golden record'?
Answer: The single authoritative, most accurate version of a data entity compiled from multiple sources
A golden record is the master, trusted version of an entity's data that is created by merging and deduplicating information from multiple source systems.
What does 'data timeliness' refer to in the context of data quality?
Answer: The degree to which data is available and up-to-date when needed for use
Timeliness measures whether data is current and accessible at the moment it is needed for decision-making or processing.
Which approach involves using statistical methods to identify records that deviate significantly from expected patterns?
Answer: Outlier detection
Outlier detection uses statistical techniques such as z-scores or interquartile range to identify data values that fall far outside the expected distribution.
A 'conformity' check in data validation ensures that:
Answer: Data values adhere to a specified format, standard, or domain of acceptable values
Conformity validation verifies that data values match a required format or standard, such as ensuring phone numbers follow the (XXX) XXX-XXXX pattern.
Which of the following is an example of a business rule validation?
Answer: Verifying that an employee's salary does not exceed their manager's salary
Business rule validations enforce organization-specific logic, such as hierarchical salary constraints, that go beyond simple format or type checks.