ADC Data Quality & Validation 2

Question 1

Cross-field validation checks which of the following?

Accepted Answer

That the relationship between two or more fields within a record is logically correct

Answer

That a field value matches a lookup table

Answer

That a field does not exceed its maximum length

Answer

That a numeric field falls within a defined range

Question 2

Which metric is used to express the percentage of records that contain all required fields with valid values?

Accepted Answer

Completeness rate

Answer

Accuracy rate

Answer

Duplication ratio

Answer

Conformity score

Question 3

In data quality management, what is a 'golden record'?

Accepted Answer

The single authoritative, most accurate version of a data entity compiled from multiple sources

Answer

A record that has passed all security audits

Answer

A backup copy stored in an offsite location

Answer

A record that has never been modified since creation

Question 4

What does 'data timeliness' refer to in the context of data quality?

Accepted Answer

The degree to which data is available and up-to-date when needed for use

Answer

How quickly data can be queried from a database

Answer

The speed at which data is written to disk

Answer

The frequency with which data is backed up

Question 5

Which approach involves using statistical methods to identify records that deviate significantly from expected patterns?

Accepted Answer

Outlier detection

Answer

Referential integrity checking

Answer

Schema validation

Answer

Format normalization

Question 6

A 'conformity' check in data validation ensures that:

Accepted Answer

Data values adhere to a specified format, standard, or domain of acceptable values

Answer

Records are unique across the dataset

Answer

The database schema matches the data dictionary

Answer

All foreign key references resolve to existing primary keys

Question 7

Which of the following is an example of a business rule validation?

Accepted Answer

Verifying that an employee's salary does not exceed their manager's salary

Answer

Ensuring a ZIP code field contains exactly 5 digits

Answer

Checking that a date field contains a valid calendar date

Answer

Confirming that a primary key column has no null values