Data Processing Data Validation and Quality 3

Question 1

What is a data audit trail?

Accepted Answer

A record of all changes made to data over time

Answer

A list of database users

Answer

A summary report of data volume

Answer

A backup of deleted records

Question 2

Which technique detects whether two related fields contain logically consistent values?

Accepted Answer

Cross-field validation

Answer

Presence check

Answer

Format check

Answer

Length check

Question 3

What is the primary purpose of data profiling?

Accepted Answer

To analyze and understand the structure, content, and quality of data

Answer

To encrypt data for secure storage

Answer

To compress large datasets for archiving

Answer

To sort data in ascending order

Question 4

What does 'data accuracy' mean in data quality terms?

Accepted Answer

Data correctly represents the real-world values it is intended to model

Answer

Data is processed faster than normal

Answer

Data files are stored without compression

Answer

Data is replicated across multiple servers

Question 5

Which approach is used to fill in missing values in a dataset?

Accepted Answer

Data imputation

Answer

Data partitioning

Answer

Data sharding

Answer

Data indexing

Question 6

What is a lookup table used for in data validation?

Accepted Answer

To verify that a field value exists within a predefined list of valid options

Answer

To store large binary files

Answer

To speed up full-table scans

Answer

To archive historical records