Data Processing Data Validation and Quality 2

Question 1

What is data deduplication?

Accepted Answer

Removing duplicate records from a dataset

Answer

Adding backup copies of data

Answer

Encrypting data for security

Answer

Sorting data alphabetically

Question 2

Which data quality dimension measures how up-to-date data is?

Accepted Answer

Timeliness

Answer

Accuracy

Answer

Completeness

Answer

Consistency

Question 3

What is referential integrity in relational databases?

Accepted Answer

Foreign keys must correspond to existing primary keys in the referenced table

Answer

All tables must have the same number of rows

Answer

Primary keys must be numeric

Answer

Tables must be sorted by the primary key

Question 4

Which method is commonly used to standardize data from multiple sources into a uniform format?

Accepted Answer

Data normalization

Answer

Data encryption

Answer

Data compression

Answer

Data archiving

Question 5

What does 'data completeness' measure?

Accepted Answer

The proportion of required data that is present and not missing

Answer

How fast data is processed

Answer

How many tables are in a database

Answer

The size of data files in gigabytes

Question 6

Which validation rule ensures a field contains only alphabetic characters?

Accepted Answer

Data type check

Answer

Range check

Answer

Presence check

Answer

Uniqueness check