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

Completeness measures whether all expected records and fields exist in the target, ensuring no data is missing during the ETL process.

Question 2

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

Accepted Answer

Reconciliation testing

Answer

Reconciliation testing compares aggregate metrics such as row counts and sum totals between source and target to detect data loss or duplication.

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

A referential integrity check ensures that foreign key values in fact tables correspond to existing primary keys in dimension tables, maintaining relational consistency.

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

Pattern or format validation uses regular expressions or format rules to confirm that field values match the required structure, such as date formats.

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

A range check validates that numeric or date values lie within a predefined acceptable range, catching outliers or corrupted data.

ETL Testing - extract, transform, load Practice Test

ETL Testing - extract, transform, load Practice Test

ETL Testing ETL Data Quality and Validation