DMC DMC ETL Processes & Data Warehousing

Question 1

What does ETL stand for in data warehousing?

Accepted Answer

Extract, Transform, Load

Answer

Encode, Transfer, Load

Answer

Export, Translate, Link

Answer

Evaluate, Test, Launch

Question 2

Which ETL phase is responsible for data cleaning and reformatting?

Accepted Answer

Transform phase

Answer

Extract phase

Answer

Load phase

Answer

Validate phase

Question 3

What is a 'staging area' in an ETL process?

Accepted Answer

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

Answer

The final production data warehouse

Answer

The operational source database

Answer

The production environment used for end-user analysis

Question 4

What is 'incremental loading' in ETL?

Accepted Answer

Loading only new or changed records since the last ETL run

Answer

Reloading all source data from scratch on every ETL run

Answer

Loading records in alphabetical or sorted order

Answer

Loading data exclusively during off-peak maintenance windows

Question 5

What is the primary purpose of data profiling in ETL?

Accepted Answer

To analyze the content, quality, and structure of source data

Answer

To compress data for faster loading performance

Answer

To create user access profiles for data security

Answer

To generate automated documentation for the ETL pipeline

Question 6

What is 'data latency' in the context of an ETL pipeline?

Accepted Answer

The delay between when data is generated in the source and when it is available in the warehouse

Answer

Corrupted data caused by network packet loss

Answer

The time required to execute a complex SQL query

Answer

The lag introduced by slowly changing dimension processing