FREE ETL Testing Basic Questions and Answers

Question 1

___ automates ETL testing and management to make sure the data don't affect production systems.

Accepted Answer

Informatica Data Validation

Answer

Irrelevant Data Validation

Answer

Irrelevant Duration Validation

Answer

Informatica Duration Validation

Question 2

Testing the changed data values against the expected data values is called ___ testing.

Accepted Answer

Source to target

Answer

Metadata

Answer

Data Transformation

Answer

Data Accuracy

Question 3

Data types, data lengths, indexes, and constraints are all measured as part of __ testing.

Accepted Answer

Metadata

Answer

Data Transformation

Answer

Data Quality

Answer

Data Accuracy

Question 4

Difficult data will be reported by __ tests if there are invalid characters, invalid character patterns, or wrong upper- or lowercase case.

Accepted Answer

Syntax

Answer

Transformation

Answer

Reference

Answer

Accuracy

Question 5

When new data is introduced to existing data, a data integrity test is performed for ___ testing.

Accepted Answer

Incremental ETL

Answer

Report

Answer

Migration

Answer

GUI/Navigation

Question 6

A ___ compares data between two systems, one source and one target, without changing the data in either system.

Accepted Answer

Value Comparison

Answer

Value Compression

Answer

Value Contraction

Answer

Value Compromise

Question 7

For both the source and destination tables, a ___ holds all the columns and their lookups in reference tables.

Accepted Answer

Mapping Sheet

Answer

DB Schema of Source

Answer

DB Schema of Target

Answer

None of the above

Question 8

QualiDI's ___ testing platform provides ETL and end-to-end testing.

Accepted Answer

Automated

Answer

Non-automated

Answer

Semi-automated

Answer

None of the above

Question 9

A data migration pipeline consists of ___ data from an input source being transformed and loaded into an output destination for analysis, reporting, and synchronization (such as a datamart, database, and data warehouse).

Accepted Answer

Extracting

Answer

Modifying

Answer

Adding

Answer

Deleting

Question 10

Which of these tasks is NOT part of the ETL Transformation Process?

Accepted Answer

Addressing

Answer

Cleaning

Answer

Filtering

Answer

Joining