MDM Data Governance & Stewardship Frameworks 2 — Questions and Answers
Question 1: In Informatica MDM, which role is primarily responsible for defining data quality rules and resolving data conflicts?
- Data Architect
- Data Steward (Correct answer)
- Database Administrator
- Business Analyst
Correct answer: Data Steward
Data Stewards are responsible for defining data quality rules, resolving data conflicts, and ensuring master data accuracy in Informatica MDM.
Question 2: Which Informatica MDM component provides a workflow engine for automating data stewardship tasks?
- MDM Hub Console
- ActiveVOS (Correct answer)
- Data Director
- Hierarchy Manager
Correct answer: ActiveVOS
ActiveVOS is the embedded workflow engine in Informatica MDM that automates data stewardship tasks such as approval workflows and notifications.
Question 3: What is the purpose of a 'trust score' in Informatica MDM's data governance model?
- It ranks users by their security clearance level
- It determines which source system's record value is most reliable for consolidation (Correct answer)
- It measures the overall health of the MDM Hub
- It calculates the cost of data quality issues
Correct answer: It determines which source system's record value is most reliable for consolidation
Trust scores determine which source system's attribute values are most reliable, guiding the MDM Hub's survivorship rules during record consolidation.
Question 4: Under a federated data governance model in MDM, how is governance authority typically distributed?
- All governance decisions are made by a central IT team
- Governance responsibility is shared between a central body and domain-specific business units (Correct answer)
- Each department governs its data independently with no central oversight
- Governance is fully outsourced to a third-party vendor
Correct answer: Governance responsibility is shared between a central body and domain-specific business units
Federated data governance distributes authority between a central governance body that sets standards and business domains that apply those standards locally.
Question 5: Which Informatica MDM feature allows stewards to review and approve proposed changes to master records before they are committed?
- Batch Merge
- Pending State workflow (Correct answer)
- Publish events
- Data Director staging
Correct answer: Pending State workflow
The Pending State workflow holds proposed master record changes in a pending queue for steward review and approval before the changes are applied.
Question 6: In the context of MDM data governance, what does a Data Governance Council primarily do?
- Writes ETL code to load data into the MDM Hub
- Sets policies, resolves escalated data issues, and sponsors MDM initiatives across the enterprise (Correct answer)
- Manages the physical server infrastructure for the MDM Hub
- Executes data quality jobs on a scheduled basis
Correct answer: Sets policies, resolves escalated data issues, and sponsors MDM initiatives across the enterprise
A Data Governance Council sets enterprise-wide data policies, resolves escalated data conflicts, and provides executive sponsorship for MDM programs.
Question 7: Which metadata artifact in Informatica MDM defines which attributes are governed, their business definitions, and data quality thresholds?
- Landing Table Schema
- Business Entity Model
- Data Dictionary / Business Glossary (Correct answer)
- IDD Application Configuration
Correct answer: Data Dictionary / Business Glossary
The Data Dictionary or Business Glossary documents governed attributes, their business definitions, owners, and quality thresholds as part of the governance framework.
MDM Data Governance & Stewardship Frameworks 2
In Informatica MDM, which role is primarily responsible for defining data quality rules and resolving data conflicts?