ETL Testing ETL Data Quality and Validation

Question 1

Which ETL data quality dimension ensures that every required record and field is present in the target dataset?

Accepted Answer

Completeness

Answer

Accuracy

Answer

Consistency

Answer

Timeliness

Question 2

What type of ETL validation compares row counts between the source and target tables after a load?

Accepted Answer

Reconciliation testing

Answer

Schema validation

Answer

Referential integrity check

Answer

Boundary testing

Question 3

In ETL testing, which check verifies that a foreign key in the target fact table references a valid primary key in the corresponding dimension table?

Accepted Answer

Referential integrity check

Answer

Null check

Answer

Data type validation

Answer

Duplicate check

Question 4

Which technique is used to validate that transformed date fields conform to a specific format such as YYYY-MM-DD?

Accepted Answer

Pattern or format validation

Answer

Referential integrity check

Answer

Checksum validation

Answer

Range check

Question 5

A range check in ETL data quality testing is primarily used to verify which of the following?

Accepted Answer

That numeric values fall within an acceptable minimum and maximum boundary

Answer

That all primary keys are unique

Answer

That source and target column counts match

Answer

That NULL values are properly handled

Question 6

Which ETL validation approach computes an MD5 or SHA hash on source data and compares it to the same hash computed on target data?

Accepted Answer

Checksum validation

Answer

Boundary testing

Answer

Null constraint testing

Answer

Metadata validation

Question 7

During ETL testing, which dimension of data quality is violated when the same customer has two different birth dates recorded in separate source systems?

Accepted Answer

Consistency

Answer

Completeness

Answer

Timeliness

Answer

Uniqueness