DA0-002 Data Acquisition and Preparation Practice Question
A data scientist is merging retail transaction data from online and in-store sources. Which THREE steps are required to ensure data consistency?
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
✓
Ensure product IDs are standardized across sources
Options A (standardize product IDs), B (convert monetary amounts to a common currency), and D (synchronize timestamps to a single time zone) are essential for data consistency when merging online and in-store transaction data. Option C (remove all transactions with missing customer ID) is not required and may discard useful data; missing customer IDs can be handled in other ways. Option E (merge using only store location) is insufficient as it ignores other identifiers and may cause mismatches.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Ensure product IDs are standardized across sources
Why this is correct
Standard IDs prevent mismatches.
- ✓
Convert all monetary amounts to a common currency
Why this is correct
Common currency enables accurate analysis.
- ✗
Remove all transactions with missing customer ID
Why it's wrong here
Removing rows may bias the dataset; imputation or flagging is better.
- ✓
Synchronize timestamps to a single time zone
Why this is correct
Common time zone prevents temporal misalignment.
- ✗
Merge data using only store location
Why it's wrong here
Store location alone is not a reliable join key.
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.