ADC Data Quality & Validation 3

Question 1

What is the main goal of data deduplication in a data quality process?

Accepted Answer

To identify and remove or merge duplicate records that represent the same real-world entity

Answer

To encrypt redundant records for archival

Answer

To convert data from one format to another

Answer

To partition large tables into smaller ones for performance

Question 2

Which data quality dimension measures how well data values align with the defined data types, formats, and domains specified in the data dictionary?

Accepted Answer

Validity

Answer

Completeness

Answer

Uniqueness

Answer

Timeliness

Question 3

In a data validation pipeline, what is the purpose of a 'reject table'?

Accepted Answer

To capture records that fail validation rules so they can be reviewed and corrected

Answer

To store records awaiting security approval

Answer

To hold archived records that are no longer active

Answer

To store aggregate summaries of failed queries

Question 4

Which technique is used to standardize inconsistently formatted data values, such as converting 'United States,' 'US,' and 'U.S.A.' to a single canonical form?

Accepted Answer

Data parsing and standardization

Answer

Data masking

Answer

Data normalization

Answer

Data lineage tracking

Question 5

A data quality scorecard is primarily used to:

Accepted Answer

Track and communicate data quality metrics across multiple dimensions over time

Answer

Rank database servers by throughput performance

Answer

Generate encryption keys for sensitive datasets

Answer

Define the ETL workflow for data ingestion

Question 6

What is 'referential integrity' in the context of relational data validation?

Accepted Answer

A constraint ensuring that a foreign key value in one table always corresponds to a valid primary key in the referenced table

Answer

A guarantee that all fields in a table have non-null values

Answer

A rule that limits the number of relationships a table can have

Answer

A check that column names match those defined in the data dictionary

Question 7

Which of the following best describes a 'data quality rule' in an ADC context?

Accepted Answer

A defined condition or constraint that data must satisfy to be considered fit for use

Answer

A performance benchmark for database query execution time

Answer

A formula used to calculate storage requirements for a dataset

Answer

A protocol for encrypting data in transit between systems