ETL Testing ETL Testing Tools and Automation

Question 1

Which open-source framework is commonly used in the US for automated ETL pipeline testing with SQL-based assertions?

Accepted Answer

dbt (data build tool) with dbt test

Answer

Selenium WebDriver

Answer

JMeter

Answer

Postman

Question 2

What is the primary purpose of Apache Griffin in the ETL testing ecosystem?

Accepted Answer

Providing a data quality measurement platform for batch and streaming pipelines

Answer

Orchestrating ETL job schedules

Answer

Generating test data for ETL pipelines

Answer

Monitoring ETL server CPU usage

Question 3

In ETL automation testing, what is a 'data diff' tool used for?

Accepted Answer

Comparing source and target datasets row-by-row to identify discrepancies automatically

Answer

Diffing ETL job configuration files

Answer

Measuring load time differences between runs

Answer

Comparing server hardware specifications

Question 4

Which AWS service is commonly tested in US-based ETL pipelines to verify that Glue jobs correctly transform data?

Accepted Answer

AWS Glue job with PyTest and GlueContext mocking

Answer

AWS Lambda test harness

Answer

AWS CloudWatch alarms only

Answer

AWS S3 versioning

Question 5

What does 'data lineage tracking' provide that is valuable for ETL testing?

Accepted Answer

A visual or programmatic map of how data flows from source to target, enabling impact analysis and root cause diagnosis

Answer

Real-time monitoring of server disk usage

Answer

A list of all ETL job execution logs

Answer

An audit of user access to the data warehouse

Question 6

Which ETL testing approach uses a known 'golden dataset' with pre-validated expected outputs to automatically verify transformations?

Accepted Answer

Golden dataset regression testing

Answer

Exploratory testing

Answer

Ad-hoc querying

Answer

Smoke testing