DA0-002 Data Acquisition and Preparation Practice Question
A retail company is acquiring sales data from 150 stores worldwide. Each store sends daily CSV files via email to a central email address. The data acquisition process is manual: an intern downloads each attachment and copies it into a shared folder. The shared folder is then accessed by an ETL tool that loads data into a data warehouse. Recently, the data warehouse has been missing records for several stores. The intern reports that some emails are not being received or are delayed. The company needs to improve the reliability and timeliness of data acquisition. Which course of action should be taken first?
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
✓
Require stores to upload CSV files directly to a cloud-based storage bucket.
Requiring stores to upload CSV files directly to a cloud-based storage bucket eliminates dependency on email and manual intervention, addressing the root cause of missing records due to email delays or non-receipt. This approach improves reliability and timeliness. Option A is wrong because it still relies on email and increases manual effort. Option B, while potentially effective, is more complex to implement as a first step compared to switching to cloud uploads. Option C is wrong because automating email parsing still depends on email reliability, which is the underlying problem.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Train the intern to check email more frequently and manually verify all attachments.
Why it's wrong here
Does not address root cause of email unreliability.
- ✗
Replace the email method with a web-based API that stores push data in real-time.
Why it's wrong here
Too complex and time-consuming as a first step.
- ✗
Implement an automated email parser that downloads attachments and moves them to the shared folder.
Why it's wrong here
Still relies on email transport, which may be unreliable.
- ✓
Require stores to upload CSV files directly to a cloud-based storage bucket.
Why this is correct
Eliminates email dependency and manual steps.
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.