ADC Data Quality & Validation

Question 1

Which data quality dimension refers to the degree to which data correctly represents the real-world construct it is intended to model?

Accepted Answer

Accuracy

Answer

Accuracy is the dimension that measures how closely data values reflect the true, real-world values they are intended to represent.

Question 2

A dataset is considered 'complete' when it:

Accepted Answer

Has all required fields populated with valid values

Answer

Completeness means all mandatory attributes are present and contain meaningful, non-null values rather than being empty or missing.

Question 3

Which validation technique checks that a data value falls within a predefined acceptable range?

Accepted Answer

Range check

Answer

A range check validates that a value lies between a minimum and maximum threshold, such as ensuring a percentage field is between 0 and 100.

Question 4

What is the primary purpose of a checksum in data validation?

Accepted Answer

To detect errors introduced during data transmission or storage

Answer

A checksum is a calculated value used to verify data integrity by detecting accidental changes or corruption during transmission or storage.

Question 5

Which of the following best describes 'data consistency'?

Accepted Answer

The same data element holds the same value across all related datasets and systems

Answer

Consistency requires that the same data item has the same value wherever it appears across different tables, databases, or systems.

ADC - Access Data Certification Practice Test