DA0-002 Data Concepts and Environments Practice Question
A data warehouse team is considering moving from an ETL to an ELT approach. Which THREE of the following are advantages of ELT over ETL?
⚠ Common exam trap
CompTIA often tests the misconception that ELT reduces storage requirements, but in reality, ELT increases storage needs because raw data is persisted alongside transformed data, whereas ETL can discard raw data after transformation.
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
✓
Reduces data loading time because transformations are done after loading
In ELT, data is loaded into the data warehouse first and transformations are applied afterward. This reduces the initial loading time since no transformation processing occurs during the load phase, allowing raw data to be ingested more quickly.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Requires less storage space in the data warehouse
Why it's wrong here
ELT stores raw data, which may require more storage than storing transformed data only.
- ✓
Reduces data loading time because transformations are done after loading
Why this is correct
Data is loaded quickly without transformation, reducing initial load time.
- ✓
Allows data to be reprocessed easily if transformation logic changes
Why this is correct
Raw data is retained, so transformations can be re-applied without re-extracting.
- ✗
Ensures data is cleaned before loading
Why it's wrong here
In ELT, data is loaded raw and cleaned later; ETL cleans before loading.
- ✓
Eliminates the need for a separate ETL server
Why this is correct
Transformations run inside the warehouse, reducing infrastructure complexity.
Go deeper
Related to this question
About these practice questions
One of 986 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.