ETL Testing ETL Data Quality and Validation 3

Question 1

Which ETL data quality practice involves sampling a subset of records from the target and manually tracing them back to the source to confirm accurate transformation?

Accepted Answer

Data lineage tracing

Answer

Regression testing

Answer

Smoke testing

Answer

Equivalence partitioning

Question 2

When an ETL process truncates a string field from 100 characters in the source to 50 characters in the target, which data quality dimension is primarily at risk?

Accepted Answer

Accuracy

Answer

Timeliness

Answer

Uniqueness

Answer

Availability

Question 3

In ETL testing, which type of test validates that records rejected during a load are written to an error or reject table with appropriate error codes?

Accepted Answer

Error handling and reject log validation

Answer

Referential integrity check

Answer

Metadata validation

Answer

SCD history validation

Question 4

Which ETL validation technique compares aggregated totals (such as SUM of sales amounts) between source and target to confirm no data was lost during loading?

Accepted Answer

Aggregate balance testing

Answer

Schema validation

Answer

Boundary testing

Answer

Pattern validation

Question 5

A data profiling step performed before ETL development primarily helps teams to do which of the following?

Accepted Answer

Understand source data structure, quality issues, and anomalies prior to designing transformations

Answer

Automate the ETL workflow schedule

Answer

Deploy the ETL pipeline to production

Answer

Generate surrogate keys for dimension tables

Question 6

Which of the following best describes a 'boundary value' test in the context of ETL data quality validation?

Accepted Answer

Testing values at the exact minimum and maximum limits of an allowed range

Answer

Confirming that all source tables have corresponding target tables

Answer

Verifying that ETL jobs complete within the defined SLA time window

Answer

Checking that dimension tables are loaded before fact tables

Question 7

In ETL testing, which term describes the practice of re-running an ETL load after a failure and validating that the target data remains accurate without duplication or data loss?

Accepted Answer

Restart and recovery testing

Answer

Incremental load testing

Answer

Full load regression testing

Answer

Parallel run testing