LFC ETL & Data Integration

Question 1

What does ETL stand for in data processing?

Accepted Answer

Extract, Transform, Load

Answer

Evaluate, Tag, Load

Answer

Extract, Transfer, Load

Answer

Encode, Translate, Log

Question 2

Why is ETL critical in a lakehouse environment?

Accepted Answer

To prepare data for analytics

Answer

To delay data loading

Answer

To minimize storage costs

Answer

To restrict user access

Question 3

Which tool is often used for data orchestration in lakehouse platforms?

Accepted Answer

Apache Airflow

Answer

TensorFlow

Answer

Grafana

Answer

Kafka Streams

Question 4

How does ELT differ from ETL in modern architectures?

Accepted Answer

Loads before transforming

Answer

Transforms data before extracting

Answer

Eliminates the transform step

Answer

Requires no schema

Question 5

Which type of data integration supports real-time processing in a lakehouse?

Accepted Answer

Streaming integration

Answer

Batch processing only

Answer

Email ETL

Answer

Manual import

Question 6

What ensures data quality during the ETL process?

Accepted Answer

Performing validation and cleansing

Answer

Skipping transform step

Answer

Compressing all data

Answer

Random data sampling