Data Processing Data Quality and Validation 2

Question 1

What is referential integrity in a relational database?

Accepted Answer

Ensuring foreign key values always reference existing primary key values

Answer

Ensuring column names follow naming conventions

Answer

Compressing reference tables for performance

Answer

Encrypting keys in lookup tables

Question 2

What is the purpose of a checksum in data validation?

Accepted Answer

To detect errors or corruption in transmitted or stored data

Answer

To speed up data retrieval

Answer

To compress large files before transfer

Answer

To sort records in ascending order

Question 3

What is data consistency in data processing?

Accepted Answer

Data is the same across all systems and does not contradict itself

Answer

All data is stored in the same file format

Answer

All queries return results in under 100 ms

Answer

All records have the same number of columns

Question 4

Which process automatically corrects or standardizes data to meet quality standards?

Accepted Answer

Data cleansing

Answer

Data archiving

Answer

Data partitioning

Answer

Data replication

Question 5

What is a null value in a database?

Accepted Answer

The absence of any value — unknown or missing data

Answer

A value of zero

Answer

A negative integer

Answer

An encrypted placeholder

Question 6

What is timeliness as a data quality dimension?

Accepted Answer

Whether data is available and up-to-date when needed

Answer

How quickly queries execute

Answer

Whether all columns have index coverage

Answer

Whether data is stored in the correct timezone