DA0-002 Data Acquisition and Preparation Practice Question
A data analyst needs to combine sales data from multiple regional databases with different schemas. Which process is best?
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)
ETL (Extract, Transform, Load) is designed to extract data from various sources, transform it to a common schema, and load it into a target system. Option A (Data federation) is wrong because it provides virtual integration without transforming data into a consistent schema. Option C (Data replication) is wrong because it copies data without transformation. Option D (Data virtualization) is wrong because it provides real-time access to disparate sources without physically storing the transformed data.
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 federation
Why it's wrong here
Data federation provides virtual integration but does not transform data into a common schema; it queries source systems on the fly.
- ✓
ETL (Extract, Transform, Load)
Why this is correct
ETL extracts data from various sources, transforms it to a consistent schema, and loads it into a target system, which is ideal for combining data from multiple databases with different schemas.
- ✗
Data replication
Why it's wrong here
Data replication copies data from one database to another without transformation; it does not handle schema differences.
- ✗
Data virtualization
Why it's wrong here
Data virtualization provides real-time access to data from multiple sources without physically moving or transforming it, which is not suitable for combining data into a single store with a common schema.
Go deeper
Related to this question
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 →
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.