MDM Data Governance & Quality Management 2 — Questions and Answers
Question 1: In Informatica MDM, which governance role is primarily responsible for defining and enforcing data quality rules for a specific business domain?
- Data Steward (Correct answer)
- System Administrator
- ETL Developer
- Database Administrator
Correct answer: Data Steward
Data Stewards own the business rules and policies for their domain and are responsible for enforcing data quality standards within Informatica MDM.
Question 2: Which Informatica MDM component provides a workflow-driven process for resolving data quality exceptions flagged during batch loads?
- Data Director (Correct answer)
- Repository Manager
- Schema Manager
- Hierarchy Manager
Correct answer: Data Director
Informatica Data Director (IDD) provides a browser-based interface with workflow capabilities that allow stewards to review and resolve data quality exceptions.
Question 3: A data quality rule in Informatica MDM rejects records where the postal code does not match the state. What type of validation is this?
- Cross-field validation (Correct answer)
- Format validation
- Completeness check
- Uniqueness constraint
Correct answer: Cross-field validation
Cross-field validation checks consistency between two or more related fields, such as verifying that a postal code aligns with the stated region.
Question 4: In Informatica MDM Hub's trust framework, what does a higher trust score for a source system indicate?
- Its values are more likely to win survivorship and populate the best version of truth (Correct answer)
- Its records are loaded first in the batch sequence
- Its records bypass all data quality checks
- Its schema is used as the canonical data model
Correct answer: Its values are more likely to win survivorship and populate the best version of truth
Higher trust scores mean a source system's attribute values take precedence during survivorship, making them the most trusted data in the golden record.
Question 5: Which governance artifact in Informatica MDM defines the authoritative list of acceptable values for a given attribute, such as country codes?
- Lookup table (Correct answer)
- Match column
- Landing table
- Cleanse function
Correct answer: Lookup table
Lookup tables in MDM Hub store reference data lists (e.g., valid country codes) that are used to validate and standardize incoming attribute values.
Question 6: When configuring a data quality policy in Informatica MDM, what is the purpose of setting a 'reject threshold' on a cleanse function?
- To route records below a quality score cutoff to a reject table for stewardship review (Correct answer)
- To limit the number of source systems that can write to the staging table
- To cap the number of records processed per batch job
- To define the maximum trust score a source system can receive
Correct answer: To route records below a quality score cutoff to a reject table for stewardship review
A reject threshold ensures that records failing to meet minimum quality standards are diverted to a reject queue rather than being merged into the golden record.
Question 7: Which Informatica MDM feature enables business users to define and maintain data governance policies without modifying the underlying schema?
- Business Entity Services (BES) (Correct answer)
- Schema Manager
- Process Server configuration
- SIF API layer
Correct answer: Business Entity Services (BES)
Business Entity Services allow business-centric configuration of validation rules and workflow policies through metadata, without requiring schema changes.
MDM Data Governance & Quality Management 2
In Informatica MDM, which governance role is primarily responsible for defining and enforcing data quality rules for a specific business domain?