ETL Testing ETL Data Quality and Validation 2

Question 1

What is the primary purpose of performing a metadata validation check in ETL testing?

Accepted Answer

To verify column names, data types, lengths, and constraints match the design specification

Answer

To confirm row counts between source and target

Answer

To test the performance of the ETL pipeline under load

Answer

To check for duplicate rows in the target table

Question 2

In an ETL pipeline, a surrogate key is typically validated to ensure which of the following properties?

Accepted Answer

It is unique and not NULL for every row in the dimension table

Answer

It matches the natural key from the source system

Answer

It is a composite key made of multiple source columns

Answer

It is populated only for slowly changing dimension Type 2 records

Question 3

Which data quality test would detect a situation where the ETL process loaded the same transaction record twice into the target table?

Accepted Answer

Duplicate record check

Answer

Null check

Answer

Referential integrity check

Answer

Range check

Question 4

When testing a Type 2 Slowly Changing Dimension (SCD), which validation confirms that historical records are correctly preserved with start and end date columns?

Accepted Answer

SCD version history validation

Answer

Checksum validation

Answer

Boundary check

Answer

Orphan record check

Question 5

An orphan record in ETL testing refers to which of the following scenarios?

Accepted Answer

A fact table row whose foreign key has no matching primary key in the dimension table

Answer

A dimension record that has never been updated since initial load

Answer

A source record that was rejected by the ETL error handler

Answer

A target record with all NULL attribute columns

Question 6

Which ETL quality metric measures the percentage of records that successfully passed all validation rules out of the total records processed?

Accepted Answer

Data acceptance rate

Answer

Data latency rate

Answer

Error rejection rate

Answer

Transformation ratio

Question 7

In ETL testing, what does a 'completeness check on a NOT NULL column' specifically verify?

Accepted Answer

That no rows exist where that column contains a NULL value

Answer

That the column length does not exceed the defined maximum

Answer

That the column values fall within an acceptable numeric range

Answer

That the column contains only unique values across all rows