Match each ETL process step to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Retrieve data from source systems
Clean, format, and apply business rules
Insert processed data into target system
Analyze source data to understand structure
Correct or remove inaccurate records
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Extract: Retrieving data from various source systems
In ETL, Extract involves retrieving data from sources, Transform involves cleaning and converting data, and Load involves writing data to a target system. Common confusions include swapping the definitions of Extract and Transform, or misattributing real-time data capture to Load.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Extract: Retrieving data from various source systems
Why this is correct
This is the correct definition of the Extract step in ETL.
Extract: Converting data into a suitable format for analysis
Why it's wrong here
Incorrect — this describes the Transform step, not Extract.
Transform: Converting data into a suitable format or structure for analysis
Why this is correct
This correctly defines the Transform step, which involves cleaning, aggregating, and reformatting data.
Transform: Retrieving data from various source systems
Why it's wrong here
Incorrect — this describes the Extract step, not Transform.
Load: Writing transformed data into a target database or data warehouse
Why this is correct
This correctly defines the Load step, which involves inserting transformed data into the final destination.
Load: Capturing changes from source systems in real time
Why it's wrong here
Incorrect — this describes Change Data Capture (CDC), not the Load step.
Go deeper
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 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 →
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.