MDM Stewardship and Workflows 4 — Questions and Answers
Question 1: In Informatica MDM, a steward wants to add a comment explaining why they approved a record with incomplete address data. Where is this comment stored?
- In the source system's audit table
- In the workflow task audit trail within the ORS (Correct answer)
- In a separate comments database outside MDM
- In the match results table
Correct answer: In the workflow task audit trail within the ORS
Steward comments are captured in the workflow task audit trail within the ORS, linking the comment to the specific task and transition event.
Question 2: An organization wants certain senior stewards to be able to approve records that junior stewards have already reviewed but escalated. Which MDM workflow feature enables this tiered approval?
- Multi-step workflow with role-based escalation transitions (Correct answer)
- Duplicate detection threshold lowering
- Batch survivorship override
- Cross-reference table partitioning
Correct answer: Multi-step workflow with role-based escalation transitions
A multi-step workflow can define sequential review states with role-based transitions, allowing junior stewards to review first and senior stewards to provide final approval.
Question 3: When Informatica MDM promotes a record to the Hub Store after workflow approval, what happens to the corresponding cross-reference records?
- They are deleted to save storage
- They are updated to reflect the approved best version of truth and linked to the golden record (Correct answer)
- They are moved to the landing zone for reprocessing
- They remain unchanged regardless of steward edits
Correct answer: They are updated to reflect the approved best version of truth and linked to the golden record
Upon promotion, cross-reference records are updated to reflect the approved state, and the golden record in the Hub Store is refreshed based on the current survivorship calculation.
Question 4: A data steward is reviewing a workflow task for a customer record and notices that the workflow has exceeded its SLA deadline. Which MDM feature should have been configured to alert management before SLA breach?
- Trust decay rule
- Workflow escalation timer (Correct answer)
- Batch job scheduler alert
- Match threshold warning
Correct answer: Workflow escalation timer
Workflow escalation timers can be configured to automatically notify supervisors or escalate tasks to a higher role when a task remains unresolved beyond a defined time limit.
Question 5: Which of the following best describes a 'draft' state in Informatica Data Director's workflow?
- A record that has been fully approved and promoted
- A record being edited by a steward but not yet submitted for review (Correct answer)
- A record waiting in the match queue
- A record that failed cleanse validation
Correct answer: A record being edited by a steward but not yet submitted for review
The Draft state means a steward has started editing a record in Data Director but has not yet submitted it to the workflow for formal review.
Question 6: In Informatica MDM, what is the effect of configuring a workflow step as 'auto-approve' for records that pass all data quality checks?
- Those records skip the human review step and are promoted directly to the Hub Store (Correct answer)
- Those records are queued for batch processing only
- Those records are flagged for manual inspection regardless
- Those records are rejected automatically
Correct answer: Those records skip the human review step and are promoted directly to the Hub Store
Auto-approve transitions allow high-quality records to bypass manual stewardship and proceed directly to the Hub Store, reducing steward workload.
Question 7: A steward unmerges two records that were previously consolidated in Informatica MDM. What is the primary result of this unmerge operation?
- Both source cross-references are deleted permanently
- The records are separated into distinct golden records, each retaining their original cross-references (Correct answer)
- One record is promoted and the other is archived
- The unmerge creates a new match rule to prevent future merging
Correct answer: The records are separated into distinct golden records, each retaining their original cross-references
Unmerging separates the previously consolidated golden record back into distinct golden records, each associated with their original source cross-references.
MDM Stewardship and Workflows 4
In Informatica MDM, a steward wants to add a comment explaining why they approved a record with incomplete address data.
Where is this comment stored?