Which of the following is a process that is used during data integration to collect, blend, and load data?

The correct answer is B. ETL. ETL stands for Extract, Transform, Load - the three-phase process used in data integration. Data is first Extracted from source systems, then Transformed (cleaned, blended, reformatted, and enriched), and finally Loaded into a target system such as a data warehouse. MDM (Master…

Data Concepts and Environments

Question

Options

AMDM
BETL
COLTP
DBI

How the community answered

(42 responses)

A
2% (1)
B
90% (38)
C
5% (2)
D
2% (1)

Explanation

ETL stands for Extract, Transform, Load - the three-phase process used in data integration. Data is first Extracted from source systems, then Transformed (cleaned, blended, reformatted, and enriched), and finally Loaded into a target system such as a data warehouse. MDM (Master Data Management) governs data consistency across systems, OLTP (Online Transaction Processing) handles real-time transactional databases, and BI (Business Intelligence) refers to the broader practice of analyzing business data - none of these describe the collect-blend-load pipeline.

Topics

#ETL#Data Integration#Data Processing#Data Loading

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice