DA0-002 Data Analysis Practice Question
Exhibit
2024-01-15 10:23:45 ERROR: DataTypeMismatchException - Column 'age' contains mixed data types: INT and VARCHAR. Pipeline 'user_profile_etl' failed.
Refer to the exhibit. Which data quality dimension is being violated?
⚠ Common exam trap
Test-takers frequently confuse consistency with uniqueness, assuming any conflict between rows must be a duplicate record issue, when in fact consistency violations involve contradictory values for the same identifier across multiple records.
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
✓
Consistency
The exhibit shows the same customer ID (C001) associated with two different customer names ('John Smith' and 'Jon Smith'), which violates the consistency dimension. Consistency requires that data values be free from contradiction and adhere to the same representation rules across the dataset. Here, the conflicting names for the same identifier break referential integrity and data uniformity.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Uniqueness
Why it's wrong here
Uniqueness is about duplicate records, not data type issues.
- ✓
Consistency
Why this is correct
Consistency ensures data formats and values are uniform; mixed data types violate this.
- ✗
Timeliness
Why it's wrong here
Timeliness refers to whether data is up-to-date, not data type issues.
- ✗
Completeness
Why it's wrong here
Completeness deals with missing values, not data type mixing.
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.