DA0-002 Data Governance Practice Question
Exhibit
Data Quality Check Report Table: customer_info Check: Non-null validation on email field Result: Failed - 1200 records have null email
Refer to the exhibit. A data analyst is reviewing a data quality report. Which of the following actions should the analyst take first?
⚠ Common exam trap
CompTIA often tests the principle that 'fix the source, not the symptom'—the trap here is that candidates jump to data cleansing actions (delete, fill, ignore) without first diagnosing why the nulls exist, which is a classic data quality management mistake.
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
✓
Investigate the source system to understand why emails are missing.
The first step in data quality remediation is root cause analysis. Without understanding why 1200 records have null emails (e.g., a source system bug, a failed ETL join, or a missing required field), any corrective action like deletion or placeholder insertion risks introducing bias or masking a systemic issue. Investigating the source system aligns with the data governance principle of 'fix the source, not the symptom.'
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Delete the 1200 records with null emails.
Why it's wrong here
Incorrect. Deleting records without understanding impact is risky.
- ✗
Fill null emails with a placeholder.
Why it's wrong here
Incorrect. Placeholder values can mislead analysis and should only be used after understanding.
- ✓
Investigate the source system to understand why emails are missing.
Why this is correct
Correct. Root cause analysis should precede any corrective action.
- ✗
Ignore the nulls as they are not critical.
Why it's wrong here
Incorrect. Ignoring data quality issues can lead to downstream problems.
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.