DA0-002 Data Acquisition and Preparation Practice Question
Exhibit
Refer to the exhibit. ``` INFO: Starting extraction from source 'SalesDB' INFO: Connected successfully. WARN: Data type mismatch in column 'Price': expected NUMERIC, found VARCHAR ERROR: Row 1523: failed to parse date '2024-02-30' INFO: Extraction completed with 1 warning and 1 error. ```
Refer to the exhibit. An analyst sees this log during data acquisition. What action should be taken first?
⚠ Common exam trap
CompTIA often tests the misconception that you should always fix the source data first, but in data acquisition, the ETL layer is the standard place to handle format conversions without altering the original source.
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
✓
Modify the ETL mapping for data types
The log shows a data type mismatch during ETL (Extract, Transform, Load) processing, where a date field is being read as a string. The correct first action is to modify the ETL mapping for data types to ensure the date string is properly cast or converted to the target date format, preventing data loss or corruption. This aligns with standard data acquisition best practices: adjust the transformation layer to handle source data anomalies before rejecting or altering the source.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Modify the ETL mapping for data types
Why this is correct
Adjusting the mapping resolves the type mismatch for all rows.
- ✗
Reject the entire dataset
Why it's wrong here
Rejecting the dataset is drastic; the issues are fixable.
- ✗
Ignore warnings and continue
Why it's wrong here
Ignoring warnings may lead to further data quality issues.
- ✗
Correct the date string in the source
Why it's wrong here
Fixing a single row does not address the systematic type mismatch.
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.