DA0-002 Data Concepts and Environments Practice Question
A data analyst needs to extract data from a transactional database and load it into a data warehouse for reporting. Which process typically transforms the data before loading it into the warehouse?
⚠ Common exam trap
The trap here is conflating ETL and ELT — candidates who skim the question miss the phrase 'transforms the data before loading' and pick ELT because it is the more modern pattern.
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
ETL (Extract, Transform, Load) transforms data in a staging area before loading it into the target warehouse, which matches the question's requirement that transformation happens before loading. This is the classic pattern for data warehouses where the target schema is fixed and data quality must be enforced upstream. ELT, by contrast, loads raw data first and transforms it inside the warehouse using its compute engine.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Data virtualization
Why it's wrong here
Data virtualisation queries source systems at run time through a virtual layer, leaving data in place, so it performs no pre-load transformation into the warehouse. It is tempting because it federates disparate sources for ad hoc reporting, which suits scenarios needing live access without replication.
- ✗
ELT
Why it's wrong here
ELT loads raw data first and transforms it inside the warehouse, so transformation occurs after loading, not before. It is tempting because warehouse compute handles transformation well, and would be correct when the target platform's engine is the intended processing layer.
- ✓
ETL
Why this is correct
ETL transforms data in a staging area before loading, satisfying the stem's requirement that transformation occur prior to warehouse load. Extract pulls from the transactional database, Transform cleanses and conforms it, then Load writes to the warehouse. ELT instead loads raw data first and transforms inside the warehouse, which contradicts the stated sequence.
- ✗
Data replication
Why it's wrong here
Replication copies data continuously between systems without transforming it, so no pre-load transformation happens. It is tempting because it moves data into the warehouse, and would be correct for maintaining a near-real-time mirror of a source database rather than preparing reporting data.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 1,004 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.