DA0-002 Data Concepts and Environments Practice Question
To consolidate data from multiple operational databases into a central repository for reporting, a company decides to transform data before loading it into the target system. Which data integration approach is being used?
⚠ Common exam trap
Test-takers frequently confuse ETL with ELT, assuming that any transformation before loading is ELT, but the key distinction is that ELT loads raw data first and transforms it later inside the target system, whereas ETL transforms data before it reaches the target.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
ETL (Extract, Transform, Load)
The scenario describes transforming data before loading it into the target system, which is the defining characteristic of ETL (Extract, Transform, Load). In ETL, data is extracted from source systems, transformed in a staging area (e.g., cleaning, aggregating, joining), and then loaded into the central repository. This approach is commonly used when the target system (e.g., a data warehouse) requires pre-processed, high-quality data for reporting.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
ETL (Extract, Transform, Load)
Why this is correct
ETL transforms data during the integration process before loading into the target.
- ✗
Data virtualization
Why it's wrong here
Data virtualisation creates a logical abstraction layer that queries source systems in real time without physically moving or persisting data, so it cannot perform the transformation step described in the stem, where data is altered before loading into a central repository. This option tempts because it is commonly used for federated reporting across disparate databases, but the scenario explicitly requires a transformation phase that only an ETL (Extract, Transform, Load) approach can execute.
- ✗
Change data capture
Why it's wrong here
Change data capture identifies changes but does not define the transformation timing.
- ✗
ELT (Extract, Load, Transform)
Why it's wrong here
In ELT, data is loaded first and transformed later in the target system.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 986-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.