An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should the analyst use?

The correct answer is D. ELT. ELT (Extract, Load, Transform) loads raw data into the destination environment first, then transforms/cleans it there. This matches the scenario: data is extracted from sources, loaded into the cloud, and cleaned afterward. ETL (Extract, Transform, Load) transforms data before…

Data Concepts and Environments

Question

Options

AETL
BAPI
CSQL
DELT

How the community answered

(45 responses)

A
11% (5)
B
4% (2)
C
7% (3)
D
78% (35)

Explanation

ELT (Extract, Load, Transform) loads raw data into the destination environment first, then transforms/cleans it there. This matches the scenario: data is extracted from sources, loaded into the cloud, and cleaned afterward. ETL (Extract, Transform, Load) transforms data before loading, which is the opposite of what is described. APIs are a data access method, not an integration pipeline pattern. SQL is a query language, not an integration technique.

Topics

#ELT#Data Integration#Cloud Computing#Data Loading

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice