DA0-002 Data Concepts and Environments Practice Question
A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?
⚠ Common exam trap
Many exam-takers confuse the data movement process (ETL) with the data validation process (reconciliation), assuming that simply extracting and loading data will automatically ensure consistency between separate systems.
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
✓
Data reconciliation
The core issue is that the sales data and returns data are inconsistent because they were not cross-verified. Data reconciliation is the process of comparing datasets to ensure they are in agreement and identifying discrepancies, such as returns not being reflected in sales figures. Without reconciliation, the analyst would not detect that the high sales number is inflated by unrecorded returns.
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 it's wrong here
ETL is a process, but the issue is lack of reconciliation, not ETL itself.
- ✓
Data reconciliation
Why this is correct
Reconciliation ensures data matches across sources.
- ✗
Data profiling
Why it's wrong here
Profiling examines data quality, but doesn't fix cross-system consistency.
- ✗
Data governance
Why it's wrong here
Governance sets policies, but doesn't directly address reconciliation.
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.