Data Processing ETL and Data Transformation

Question 1

What does ETL stand for in data processing?

Accepted Answer

Extract, Transform, Load

Answer

Export, Transfer, Log

Answer

Evaluate, Test, Launch

Answer

Encode, Transmit, Link

Question 2

What happens during the 'Extract' phase of an ETL process?

Accepted Answer

Data is pulled from one or more source systems

Answer

Data is cleaned and converted to a target format

Answer

Data is written into the destination database

Answer

Data is compressed and archived

Question 3

What is data mapping in an ETL pipeline?

Accepted Answer

Defining how source fields correspond to destination fields

Answer

Creating geographic visualizations from address data

Answer

Encrypting data before transport

Answer

Sorting data by geographic region

Question 4

What is the purpose of a staging area in ETL processing?

Accepted Answer

A temporary storage location where data is held between extraction and loading

Answer

The final destination for processed data

Answer

A backup of the production database

Answer

A tool for visualizing ETL pipeline performance

Question 5

Which transformation converts data from one format to another, such as date formats?

Accepted Answer

Data conversion

Answer

Data masking

Answer

Data partitioning

Answer

Data archiving

Question 6

What is incremental loading in ETL?

Accepted Answer

Loading only new or changed records since the last ETL run

Answer

Loading one record at a time in sequence

Answer

Loading data in alphabetical order

Answer

Loading all data from scratch every time