FREE ETL Testing Trivia Questions and Answers

Question 1

Which of the following organizes or generates transformation sets?

Accepted Answer

Mapplet

Answer

Workflow

Answer

Session

Answer

Worklet

Question 2

Converting data from one form to another is a part of the ___ process.

Accepted Answer

Transforming

Answer

Extracting

Answer

Loading

Answer

None of the above

Question 3

Errors can be corrected in _______ based on the Metadata of a set of specified rules.

Accepted Answer

Cleansing

Answer

Source Analysis

Answer

Data Analysis

Answer

Data Profiling

Question 4

In the database, facts and aggregate facts are put into hierarchical groups called _____.

Accepted Answer

Dimensions

Answer

Dataset

Answer

Deadlock

Answer

Data

Question 5

What tasks does a business analyst perform?

Accepted Answer

Requirements are gathered and documented by the business analyst.

Answer

These plans and scripts are developed by Business Analysts and then executed by them.

Answer

Each module is tested by a Business Analyst.

Answer

The test environment is set up by Business Analyst people.

Question 6

What does UAT stand for?

Accepted Answer

User Acceptance Testing

Answer

User Attribute Testing

Answer

User Analyst Testing

Answer

None of the above

Question 7

Tests for ___ are generated automatically, saving time for test developers.

Accepted Answer

Application Upgrades

Answer

Data Transformation

Answer

Data Quality

Answer

Data Accuracy

Question 8

___ bugs are bugs that check for minimums and maximums.

Accepted Answer

Boundary value analysis

Answer

Race Condition

Answer

Calculation

Answer

Load Condition

Question 9

Because of the ____ bug, the application is accepting invalid values while rejecting valid values.

Accepted Answer

Input-output

Answer

Boundary value analysis

Answer

Calculation

Answer

Load Condition

Question 10

A group of ___ operators can be used to verify the data accuracy of the source and target.

Accepted Answer

SQL

Answer

Relational

Answer

Database

Answer

None of the above