MDM Data Governance & Stewardship Frameworks 3 — Questions and Answers
Question 1: What is the primary goal of data stewardship exception management in Informatica MDM?
- To automatically delete duplicate records without human intervention
- To identify, route, and resolve data quality exceptions that cannot be handled by automated rules (Correct answer)
- To archive inactive master records to cold storage
- To generate compliance reports for external auditors
Correct answer: To identify, route, and resolve data quality exceptions that cannot be handled by automated rules
Exception management routes data quality issues that fall outside automated rule thresholds to stewards for manual review and resolution.
Question 2: In Informatica Data Director (IDD), what is the 'Merge Manager' task used for?
- Scheduling batch data loads from source systems
- Allowing stewards to manually review and approve or reject proposed record merges (Correct answer)
- Configuring match rules in the MDM Hub Console
- Publishing master records to downstream systems
Correct answer: Allowing stewards to manually review and approve or reject proposed record merges
Merge Manager in IDD provides stewards with a UI to review match candidates and manually approve or reject proposed record merges.
Question 3: Which Informatica MDM governance concept ensures that every master data attribute has an identified business owner accountable for its quality?
- Record Survivorship
- Data Ownership / Data Accountability (Correct answer)
- Match-Merge Processing
- Consolidation Indicator
Correct answer: Data Ownership / Data Accountability
Data Ownership assigns a named business owner to each governed attribute, making accountability explicit within the governance framework.
Question 4: How does Informatica MDM support audit trails as part of its data governance framework?
- By storing only the latest version of each master record
- By logging all changes to master records, including who made the change and when, in the cross-reference (XREF) tables (Correct answer)
- By encrypting all master records at rest
- By archiving source system logs outside the MDM Hub
Correct answer: By logging all changes to master records, including who made the change and when, in the cross-reference (XREF) tables
Informatica MDM maintains a full audit trail of master record changes—including change source, user, and timestamp—through the cross-reference and history tables.
Question 5: What distinguishes a 'golden record' from a 'cross-reference record' in Informatica MDM governance terminology?
- A golden record is a duplicate; a cross-reference record is the master
- A golden record is the consolidated best-version master record; a cross-reference record links back to contributing source system records (Correct answer)
- A golden record resides in the source system; a cross-reference record is in the Hub Store
- There is no functional difference between the two
Correct answer: A golden record is the consolidated best-version master record; a cross-reference record links back to contributing source system records
The golden record is the authoritative consolidated master record, while cross-reference records preserve the linkage to original source system contributions.
Question 6: In a DACI governance model applied to MDM, what does the 'C' (Consulted) role represent?
- The person who makes the final data governance decision
- Stakeholders whose input is sought before a data governance decision is made (Correct answer)
- The individual accountable for overall MDM program success
- Those who are notified after a decision is made
Correct answer: Stakeholders whose input is sought before a data governance decision is made
In DACI, Consulted parties are subject-matter experts or stakeholders who provide input before governance decisions are finalized.
Question 7: Which Informatica MDM feature enables organizations to enforce data governance policies by restricting which source systems can update specific master record attributes?
- Hierarchy Manager
- Trust and Validation Rules with Source System Ranking (Correct answer)
- IDD Role-Based Access Control
- ActiveVOS Task Assignment
Correct answer: Trust and Validation Rules with Source System Ranking
Trust rules combined with source system ranking enforce governance policies by controlling which systems have authority to update specific master record attributes.
MDM Data Governance & Stewardship Frameworks 3
What is the primary goal of data stewardship exception management in Informatica MDM?