DA0-002 Data Governance Practice Question
A logistics company maintains a master customer table used by billing, operations, and analytics. Two source systems submit conflicting addresses for the same customer, and reports now disagree. Which governance practice should be applied to resolve the conflict and prevent recurrence?
⚠ Common exam trap
The trap here is assuming that a technical fix, such as more frequent loading, resolves conflicting data when the real issue is undefined authority and survivorship.
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
✓
Define a survivorship rule with a documented system of record and apply it during master data consolidation
Conflicting source values are resolved through survivorship rules that encode which system or attribute wins, coupled with an explicitly designated system of record. Applying those rules during consolidation yields a single golden record that all consumers share, eliminating disagreement and giving stewards a repeatable decision framework. Faster refreshes, per-system copies, or removing the attribute each leave the underlying authority question unanswered.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Archive both source records and report only the customer identifier without an address attribute
Why it's wrong here
Dropping the address attribute removes the conflict superficially but destroys business value, because billing and operations depend on accurate addresses. Archiving the sources preserves evidence but supplies no rule for choosing a value. The requirement is a consistent, authoritative address across systems, which suppressing the attribute does not deliver.
- ✗
Allow each consuming system to keep its own address and add a note explaining the discrepancy
Why it's wrong here
Permitting divergent copies institutionalizes the conflict rather than resolving it, and downstream reports will continue to disagree. Documentation of the discrepancy does not create an authoritative value or accountability for correcting it. Since the company needs one trusted customer view, this approach contradicts the purpose of master data governance.
- ✗
Increase the frequency of the nightly extract so conflicting addresses are overwritten sooner
Why it's wrong here
Refreshing more often does not decide which value is correct; it simply propagates whichever source loads last, making the outcome timing-dependent and unpredictable. Reports could still disagree between loads, and no accountability is established. Because the root problem is conflicting authority rather than staleness, faster extraction leaves the governance gap unresolved.
- ✓
Define a survivorship rule with a documented system of record and apply it during master data consolidation
Why this is correct
Survivorship rules specify which source value prevails when records conflict, and designating a system of record anchors that decision in an authoritative source. Applying the rule during consolidation produces one consistent golden record, so billing, operations, and analytics stop diverging. This directly resolves the conflict and establishes a repeatable standard that prevents the same dispute from recurring.
Visual reference
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 1,004-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 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.