DA0-002 Data Acquisition and Preparation Practice Question
Exhibit
Refer to the exhibit. Data Import Log: [2024-03-15 10:22:34] INFO: Starting import from source 'sales_raw.csv' [2024-03-15 10:22:35] WARN: Row 1502: 'price' field contains non-numeric value '12.5A'. Skipping row. [2024-03-15 10:22:36] ERROR: Row 3450: 'date' field value '2024-02-30' is invalid. Import halted. [2024-03-15 10:22:36] INFO: Import process terminated with errors.
Based on the exhibit, what is the most likely cause of the import failure?
⚠ Common exam trap
The trap here is that candidates may overlook semantic data quality issues (like invalid dates) and instead focus on syntactic problems (like file format or non-numeric characters), even though the exhibit clearly shows a date that does not exist in the calendar.
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
✓
A data quality issue: the date field contains an invalid date.
The exhibit shows a date field containing '2023-02-30', which is an invalid date (February never has 30 days). This data quality issue causes the import to fail, as the system likely validates date values against calendar rules before inserting them into the target table. The error is not due to file emptiness, non-numeric characters, or corruption, but specifically a semantic data integrity violation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The file is empty or contains only headers.
Why it's wrong here
Rows were processed, so the file has data.
- ✗
The price field includes non-numeric characters that cannot be parsed.
Why it's wrong here
That row was skipped but import continued.
- ✗
The source file is corrupted or in an unsupported format.
Why it's wrong here
The file was opened and rows processed until row 3450.
- ✓
A data quality issue: the date field contains an invalid date.
Why this is correct
The date '2024-02-30' is invalid and caused the import to halt.
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.