ETL Testing ETL Testing Tools and Automation 2

Question 1

What is the role of Apache Airflow in an ETL testing strategy?

Accepted Answer

It orchestrates ETL workflow execution and can trigger automated test tasks as pipeline steps

Answer

It generates test data for ETL pipelines

Answer

It provides a GUI for writing ETL transformation rules

Answer

It replaces the data warehouse with in-memory storage

Question 2

In ETL test automation, what is 'parameterized testing'?

Accepted Answer

Testing ETL jobs with different input datasets or configuration values to verify behavior across multiple scenarios

Answer

Setting database connection parameters for testing

Answer

Parameterizing server credentials in test scripts

Answer

Testing only the parameter columns in the target table

Question 3

Which tool or approach is commonly used to generate large volumes of synthetic test data for ETL load testing in US data engineering teams?

Accepted Answer

Faker library or Mockaroo to generate realistic synthetic records at scale

Answer

Copying live production data without masking

Answer

Manual data entry in Excel

Answer

Only using the production database snapshot

Question 4

What does CI/CD integration for ETL testing mean in practice?

Accepted Answer

Automatically executing ETL test suites on every code commit using pipelines like Jenkins or GitHub Actions

Answer

Running ETL tests manually before each release

Answer

Continuously loading data without testing

Answer

Deploying ETL changes without review

Question 5

Which type of ETL testing tool compares query results between a legacy system and a new ETL pipeline to validate migration accuracy?

Accepted Answer

Parallel run / shadow testing tool

Answer

Performance profiler

Answer

Scheduling utility

Answer

Schema migration tool

Question 6

In ETL test management, what is a 'test harness'?

Accepted Answer

A framework of automated scripts, fixtures, and utilities that set up test conditions, execute ETL jobs, and validate results

Answer

The physical server rack where ETL runs

Answer

A load balancer for ETL processes

Answer

A backup utility for test data