ETL Testing ETL Performance and Scalability Testing 2

Question 1

What is 'ETL stress testing'?

Accepted Answer

Pushing the ETL pipeline beyond its normal capacity limits to observe how it behaves and fails under extreme conditions

Answer

Testing the ETL pipeline under normal expected load conditions

Answer

Running the ETL once and measuring the baseline time

Answer

Testing the stress level of the ETL development team

Question 2

Which database technique can dramatically improve ETL load performance by dividing large tables into smaller physical segments?

Accepted Answer

Table partitioning

Answer

Adding more VARCHAR columns

Answer

Increasing the number of NULL values

Answer

Removing primary keys

Question 3

In ETL performance testing, what is a 'baseline measurement'?

Accepted Answer

An initial performance benchmark recorded under normal conditions, used as a reference point for future comparison

Answer

The minimum acceptable data quality score

Answer

The lowest row count ever observed in the target

Answer

The network baseline speed of the ETL server

Question 4

What ETL bottleneck does 'partition pruning' help address in performance testing?

Accepted Answer

Full table scans on partitioned tables by eliminating irrelevant partitions from query execution

Answer

Slow transformation logic in Python scripts

Answer

Slow network file transfers

Answer

Slow ETL scheduling overhead

Question 5

Which ETL performance test validates that parallel job streams do not cause database contention or deadlocks?

Accepted Answer

Concurrency / multi-user load test

Answer

Single-thread performance test

Answer

Schema validation test

Answer

Data completeness test

Question 6

What is 'pushdown optimization' in ETL performance, and why is it tested?

Accepted Answer

Offloading transformation processing to the database engine rather than the ETL server to leverage native SQL optimization

Answer

Pushing transformation logic down to junior developers

Answer

Pushing data down from cloud to on-premises

Answer

Moving indexes from memory to disk