DA0-002 Data Governance Practice Question
An insurer's data governance team discovers that a legacy reporting pipeline transforms policy effective dates using a hard-coded time zone offset that was correct five years ago but is now wrong for a newly acquired business unit. The team must document where the defect originates, which downstream reports are affected, and how to prevent recurrence. Which governance capability is MOST directly suited to this investigation?
⚠ Common exam trap
The trap here is assuming data profiling can identify transformation logic errors, when profiling only surfaces value-level anomalies.
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
✓
Data lineage, which maps source-to-target transformations and downstream dependencies across the pipeline
Lineage is the capability that records transformation logic and dependency chains, making it the right tool to locate the hard-coded offset and trace every downstream report affected by it. Profiling detects value anomalies without explaining logic, masking protects non-production data, and retention manages lifecycle duration. Only lineage ties the defect's origin to its consumers for impact assessment and regression planning.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Data masking, which obfuscates sensitive fields so non-production environments can be used safely
Why it's wrong here
Masking protects privacy by replacing sensitive values in lower environments. It neither explains transformation logic nor identifies downstream consumers of a field. Applying masking would not help locate the erroneous time zone offset or determine which reports are affected, so it is irrelevant to this root cause and impact analysis.
- ✓
Data lineage, which maps source-to-target transformations and downstream dependencies across the pipeline
Why this is correct
Lineage documents how data moves and transforms from source systems through each processing step to consuming reports. That lets the team pinpoint the transformation containing the hard-coded offset and enumerate every downstream report and dashboard that inherits the defect, directly supporting both impact assessment and a targeted fix with regression testing.
- ✗
Data retention scheduling, which automates archival and deletion of records past their required lifecycle
Why it's wrong here
Retention scheduling manages how long data is kept and when it is purged. It has no bearing on transformation correctness or dependency mapping. The defect stems from flawed logic in a pipeline step, not from improper lifecycle management, so retention automation would not reveal the origin of the error or the reports consuming the bad dates.
- ✗
Data profiling, which statistically summarizes column distributions to detect outliers and anomalies
Why it's wrong here
Profiling characterizes values, such as ranges and frequency distributions, and can flag odd date patterns. However, it does not reveal the transformation logic, the hard-coded offset, or which downstream reports consume the affected field. The team needs to trace the logic and its consumers, which profiling alone cannot provide for this root cause analysis.
Go deeper
Related to this question
About these practice questions
One of 1,004 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.