Informatica Master Data Management (MDM) Certification — Questions and Answers

Question 1: Which role is responsible for approving tasks in a typical workflow configuration?

UI Designer
System Analyst
Data Steward (Correct answer)
Database Administrator

Correct answer: Data Steward

In a typical MDM workflow configuration, the Data Steward plays a critical role in approving tasks. They are responsible for ensuring the quality, accuracy, and compliance of master data, making them the ideal individuals to review and approve data changes or new record creations. Their approval ensures that data adheres to established governance policies before being integrated into the master data hub.

Question 2: A data steward needs to model a 'Customer' entity that will serve as the single source of truth, consolidating data from multiple source systems. Which type of table in the Informatica MDM data model should be used for this purpose?

Base Object (Correct answer)
Landing Table
Cross-reference Table
Staging Table

Correct answer: Base Object

The Base Object is the core table in the MDM data model where the consolidated, master version of the data (the 'golden record') is stored. It represents the single source of truth for a business entity after data has been cleansed, matched, and merged.

Question 3: How does a task flow improve workflow execution?

By encrypting workflow files.
By organizing and automating task sequences (Correct answer)
By disabling user roles.
By removing data validation steps.

Correct answer: By organizing and automating task sequences

A task flow improves workflow execution by providing a structured way to organize and automate a series of related tasks. It defines the order, dependencies, and conditions under which tasks are performed, ensuring a consistent and efficient process. This automation reduces manual effort, minimizes errors, and accelerates the completion of complex business operations within MDM.

Question 4: In Informatica MDM Hub, what is a 'base object extension' and when is it used?

An additional set of columns added to a base object to store domain-specific attributes beyond the core entity definition (Correct answer)
A child table that stores overflow attributes for records exceeding the base object column limit
A configuration file that extends the default match rules with custom logic
A separate schema used to archive historical versions of base object records

Correct answer: An additional set of columns added to a base object to store domain-specific attributes beyond the core entity definition

A base object extension is used to add supplementary columns to a base object without altering its core structure, allowing domain-specific attributes to be stored alongside the master record.

Question 5: In Informatica MDM, what is the role of the 'Merge Manager' (part of the Data Stewardship Portal)?

It manages the trust configuration and survivorship rules for each base object
It is a batch utility that schedules and monitors match and merge jobs
It provides a UI for data stewards to review potential duplicates and approve or reject manual merges (Correct answer)
It automatically resolves all pending merges without human input

Correct answer: It provides a UI for data stewards to review potential duplicates and approve or reject manual merges

Merge Manager is the Data Stewardship Portal screen where data stewards review candidate duplicate record pairs surfaced by the match process and decide whether to merge or unlink them.

Question 6: A company wants to implement a rule stating that a customer's 'Date of Birth' from the CRM system is more reliable than the same information from the Billing system. Which MDM Hub feature is used to configure this survivorship logic?

Trust Scores (Correct answer)
Validation Rules
State Management
Hierarchy Manager

Correct answer: Trust Scores

Trust Scores are assigned to source systems for specific attributes to determine reliability. A higher trust score indicates greater preference. In the survivorship process, the MDM Hub uses these scores to decide which source system's value will populate the 'golden record' in the Base Object.

Question 7: In Informatica MDM SIF, what is a 'SiperianObjectUIDList' used for?

To specify the order of fields returned in a SIF response
To define a list of allowed SIF operations for a given security role
To pass multiple object identifiers in a single SIF request targeting several records at once (Correct answer)
To enumerate base objects in a specific ORS for metadata retrieval

Correct answer: To pass multiple object identifiers in a single SIF request targeting several records at once

SiperianObjectUIDList allows a single SIF request to reference multiple records by supplying a list of their unique identifiers.

Question 8: When an Informatica MDM batch group is configured with a 'Stage and Load' job sequence, what is the risk of running multiple batch groups concurrently against the same base object?

Delta detection results can conflict, leading to missed or duplicated record processing (Correct answer)
Duplicate XREF entries can be created, causing orphaned cross-references
Trust scores are recalculated globally, resetting all prior survivorship decisions
The match threshold is automatically lowered to compensate for increased data volume

Correct answer: Delta detection results can conflict, leading to missed or duplicated record processing

Running concurrent stage/load jobs against the same base object can cause race conditions where delta detection windows overlap, resulting in records being skipped or processed twice.

Question 9: What is the primary purpose of data modeling in MDM?

To replace legacy systems.
To monitor application uptime.
To improve network performance.
To define and standardize master data structures (Correct answer)

Correct answer: To define and standardize master data structures

The primary purpose of data modeling in Master Data Management (MDM) is to define, structure, and standardize the organization's critical master data. This involves identifying entities, attributes, and relationships to create a consistent and accurate representation of core business data across all systems. A robust data model ensures data quality and integrity.

Question 10: In Informatica MDM, what does a HUB_STATE_IND value of '1' typically represent for a staging record?

The record represents a delete from the source system
The record failed validation and is in error state
The record is active and has been successfully loaded
The record is new and pending load into the base object (Correct answer)

Correct answer: The record is new and pending load into the base object

A HUB_STATE_IND of 1 indicates the record is new (pending) and has not yet been promoted to the base object by the load job.

Question 11: Which Informatica MDM API security mechanism requires callers to pass a session token obtained from an initial login call?

API keys in request headers
SAML assertions embedded in each call
OAuth 2.0 bearer tokens
MDM Hub SIF session tokens (Correct answer)

Correct answer: MDM Hub SIF session tokens

The MDM Hub Services Integration Framework (SIF) uses session tokens obtained via a login() call that must be passed with all subsequent API requests to authenticate the caller.

Question 12: A compliance requirement mandates that a complete, unaltered history of all data received from a specific source system must be retained for auditing purposes, exactly as it appeared in the landing table at the time of each stage job run. How can this be achieved in Informatica MDM?

Enable History for the Base Object.
Enable the Audit Trail (RAW) property on the staging table. (Correct answer)
Configure Delta Detection with a long retention period.
Use a post-load user exit to copy data to a separate archive.

Correct answer: Enable the Audit Trail (RAW) property on the staging table.

The Audit Trail property, when enabled on a staging table, creates an associated _RAW table. This table stores a copy of the raw, unclean data from the landing table for each stage job run, serving as a historical audit log. [1, 3, 5]

Question 13: In Informatica MDM Hub, what distinguishes a 'base object' from a 'staging table'?

A base object is read-only while a staging table allows bulk updates
A base object stores the consolidated master records while a staging table holds pre-processed source data (Correct answer)
A base object stores raw source data while a staging table stores golden records
A base object is used only for hierarchy data while a staging table handles transactional data

Correct answer: A base object stores the consolidated master records while a staging table holds pre-processed source data

Base objects in MDM Hub contain the consolidated golden records, while staging tables hold raw source data that has been loaded but not yet merged.

Question 14: Which MDM Hub configuration controls how frequently the batch consolidation job runs automatically in a scheduled integration scenario?

The trust framework recalculation interval
The staging table partition policy
The job scheduler configuration within the MDM Hub or an external scheduler like Control-M (Correct answer)
The Hub Server's JVM memory settings

Correct answer: The job scheduler configuration within the MDM Hub or an external scheduler like Control-M

Batch consolidation jobs are scheduled via the MDM Hub's built-in scheduler or an external enterprise scheduler, controlling the frequency of match-merge cycles.

Question 15: In Informatica MDM, what is the consequence of setting a match column's search level to 'Exact' instead of 'Fuzzy'?

All records are treated as duplicates regardless of their values
The column is excluded from the match key and ignored during comparison
Only records with identical values for that column are considered potential matches, reducing false positives but potentially missing true duplicates (Correct answer)
The column is used only for cleansing, not matching

Correct answer: Only records with identical values for that column are considered potential matches, reducing false positives but potentially missing true duplicates

An 'Exact' match level requires character-for-character equality, which increases precision but may miss true matches with minor variations like typos.

Question 16: In Informatica MDM, which security practice should be applied to the MDM Hub's database service account to minimize risk?

Use the same service account for both MDM Hub and the application server
Store the database password directly in the hub-conf.xml file in plaintext
Restrict the service account to only the specific schemas and operations MDM Hub requires (Correct answer)
Grant the service account DBA privileges for maximum compatibility

Correct answer: Restrict the service account to only the specific schemas and operations MDM Hub requires

The MDM Hub database service account should follow least-privilege principles, having only the permissions needed to access CMX_SYSTEM and ORS schemas with the specific operations MDM requires.

Question 17: In Informatica MDM Hub, which workflow action transitions a record from 'PENDING' state back to 'DRAFT' for additional corrections?

Reject
Approve
Send Back (Correct answer)
Escalate

Correct answer: Send Back

The 'Send Back' action returns a record to DRAFT state, allowing the originator to make corrections before resubmitting for approval.

Question 18: Which of the following configuration settings are managed at the Master Database (CMX_SYSTEM) level rather than within a specific Operational Reference Store (ORS)?

Match Rule Sets and Cleanse Functions
Mappings and Hierarchies
User Accounts, Security Providers, and Message Queue Servers (Correct answer)
Base Objects and Staging Tables

Correct answer: User Accounts, Security Providers, and Message Queue Servers

The Master Database (CMX_SYSTEM) schema stores the global configuration for the entire MDM Hub environment. This includes system-wide settings like user accounts, security configurations (like LDAP), the registry of all ORS databases, and the configuration for message queue servers. In contrast, data model components like Base Objects, match rules, and mappings are specific to each ORS.

Question 19: When configuring a hierarchy relationship in MDM Hub to support multiple inheritance (a child having more than one parent), which setting must be enabled?

Set Cardinality to Many-to-Many on the entity
Configure Cross-Reference mapping for the child object
Allow Multiple Parents on the Relationship Type (Correct answer)
Enable Polymorphic Hierarchy in Hub Console

Correct answer: Allow Multiple Parents on the Relationship Type

Enabling 'Allow Multiple Parents' on the Relationship Type configuration permits a single child node to be linked to more than one parent node simultaneously.

Question 20: What is the purpose of data profiling in an MDM implementation?

To restrict user access to sensitive data fields
To analyze existing data to understand its quality, structure, and content before migration (Correct answer)
To compress data for faster processing
To create backup copies of production databases

Correct answer: To analyze existing data to understand its quality, structure, and content before migration

Data profiling examines source data to identify quality issues (duplicates, missing values, inconsistencies), understand data patterns, and plan data cleansing strategies before loading into the MDM hub.

Question 21: Which of the following ensures consistency during system-to-system updates?

Data encryption.
Version control and transactional integrity (Correct answer)
Table locking.
Auditing logs only.

Correct answer: Version control and transactional integrity

Version control and transactional integrity are crucial for ensuring consistency during system-to-system updates. Version control tracks changes to data, allowing for rollbacks and auditing, while transactional integrity ensures that data operations are atomic, consistent, isolated, and durable (ACID properties). Together, they prevent data corruption and maintain a reliable state across integrated systems.

Question 22: Which Informatica MDM feature allows different users to see different subsets of the same base object records based on their organizational context?

Secure resources
Data filters (Correct answer)
Hierarchy Manager security
Data stewardship roles

Correct answer: Data filters

Data filters in Informatica MDM restrict the records a user can access by appending filter conditions to queries based on user attributes.

Question 23: In Informatica MDM, which log or table should an administrator first consult to diagnose why records are not appearing in the base object after a load job completes?

The reject/error table and batch job log (Correct answer)
The match analysis report
The XREF table audit trail
The trust configuration history

Correct answer: The reject/error table and batch job log

The reject/error table captures records that failed validation or constraint checks, and the batch job log records execution details and error messages, making them the first diagnostic resources.

Question 24: Which MDM Hub feature allows administrators to track how a golden record's field values have changed over time?

Audit Manager
Cross-Reference History log
History Viewer
Timeline Manager (Correct answer)

Correct answer: Timeline Manager

Timeline Manager provides a temporal view of golden record changes, showing which source contributed which value at each point in time.

Question 25: When configuring a hierarchy in Informatica MDM Hub, what does the 'Relationship Type' setting control?

The data type of the relationship key column
The maximum depth of the hierarchy tree
The display order of child nodes in the UI
The cardinality and direction of relationships between hierarchy nodes (Correct answer)

Correct answer: The cardinality and direction of relationships between hierarchy nodes

Relationship Type defines cardinality (one-to-one, one-to-many) and directionality between parent and child nodes in a hierarchy.

Question 26: What does the 'promote' operation accomplish within the Informatica MDM load process?

It moves cleansed and validated staging records into the base object table (Correct answer)
It elevates a pending record to be the system-of-record winner
It converts unmerged clusters into consolidated golden records
It applies trust decay rules to aging records

Correct answer: It moves cleansed and validated staging records into the base object table

Promotion is the step within the load job where records that passed cleansing and validation are written from staging into the base object, making them part of the hub.

Question 27: What happens in Informatica MDM when a user belongs to multiple roles that have conflicting privileges on the same secure resource?

The least restrictive privilege always wins (Correct answer)
MDM throws an access denied error
The system uses the last applied role
The most restrictive privilege always wins

Correct answer: The least restrictive privilege always wins

Informatica MDM uses a permissive privilege model where the effective permission is the union of all privileges granted across all assigned roles.

Question 28: When integrating Informatica MDM with an upstream ERP system, what is the recommended approach to handle large initial data loads (millions of records)?

Directly insert records into the base object tables using SQL scripts
Use SIF API calls to insert records one at a time
Use bulk batch loading via PowerCenter or IICS pipelines into staging tables, followed by batch consolidation jobs (Correct answer)
Manually import CSV files through the Hub Console's import wizard

Correct answer: Use bulk batch loading via PowerCenter or IICS pipelines into staging tables, followed by batch consolidation jobs

Large initial loads should use bulk ETL tools (PowerCenter or IICS) to populate staging tables efficiently, followed by batch consolidation to process matches and build golden records.

Question 29: Which tool is commonly used for data integration in MDM environments?

Informatica PowerCenter (Correct answer)
Adobe Illustrator.
MS Paint.
Notepad++.

Correct answer: Informatica PowerCenter

Informatica PowerCenter is a leading enterprise data integration platform widely recognized and used in MDM environments. It provides robust capabilities for ETL (Extract, Transform, Load) processes, data quality, and data governance, enabling organizations to integrate and manage master data from various sources effectively. Its comprehensive features make it a popular choice for complex integration needs.

Question 30: A data integration architect notices that source records from System A frequently override higher-quality data from System B. Which MDM configuration should be adjusted?

Increase the match threshold for System A records
Disable delta detection for System B
Lower the trust score assigned to System A for the affected attributes (Correct answer)
Set System A's staging table to read-only mode

Correct answer: Lower the trust score assigned to System A for the affected attributes

Reducing the trust score for System A's attributes ensures that System B's higher-quality values survive the consolidation process and populate the golden record.

Question 31: What is a 'Package' in the context of Informatica MDM Hub Services Integration Framework (SIF)?

A bundled deployment artifact containing hub configurations
A reusable cleanse function library
A batch job definition for loading data
A named query definition that exposes base object data via SIF APIs (Correct answer)

Correct answer: A named query definition that exposes base object data via SIF APIs

A Package in MDM Hub SIF is a named, predefined query that defines which base object columns and relationships are exposed through the SIF API for reading or writing master data.

Question 32: When configuring a data quality policy in Informatica MDM, what is the purpose of setting a 'reject threshold' on a cleanse function?

To cap the number of records processed per batch job
To limit the number of source systems that can write to the staging table
To route records below a quality score cutoff to a reject table for stewardship review (Correct answer)
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 33: Which synchronization pattern does Informatica MDM use when it pushes updated golden records back to subscribing source systems?

Batch-Append
Polling-Pull
Publish-Subscribe (Correct answer)
Request-Reply

Correct answer: Publish-Subscribe

Informatica MDM uses the publish-subscribe pattern, where the Hub publishes updated golden records as events and subscribing source systems receive those updates.

Question 34: What governance challenge does 'party data' management address in MDM, particularly for financial services organizations?

Managing product catalog hierarchies across subsidiaries
Maintaining a single, consistent view of customers, counterparties, and legal entities to support KYC, AML, and regulatory compliance (Correct answer)
Managing employee payroll data across multiple HR systems
Synchronizing transaction records between banking systems

Correct answer: Maintaining a single, consistent view of customers, counterparties, and legal entities to support KYC, AML, and regulatory compliance

Party data management in financial services MDM focuses on creating a single trusted view of all parties for KYC, AML, and regulatory reporting compliance.

Question 35: What is the primary goal of data governance?

To provide data analytics training.
To automate all business processes.
To ensure data is managed properly and securely (Correct answer)
To reduce data storage costs.

Correct answer: To ensure data is managed properly and securely

Data governance establishes policies, processes, and responsibilities to ensure that an organization's data is managed effectively and securely throughout its lifecycle. Its primary goal is to maintain data quality, compliance, and availability, enabling reliable decision-making and mitigating risks. This structured approach ensures data assets are trustworthy and used appropriately.

Question 36: In Informatica MDM's IDD, what is the purpose of role-based access control (RBAC) in a governance context?

To configure match and merge thresholds
To ensure that users can only view or edit data appropriate to their governance role, enforcing separation of duties (Correct answer)
To improve MDM Hub query performance
To route workflow tasks to the correct ActiveVOS process

Correct answer: To ensure that users can only view or edit data appropriate to their governance role, enforcing separation of duties

RBAC in IDD enforces governance principles by restricting data access and edit permissions based on a user's defined governance role, ensuring separation of duties.

Question 37: An organization wants to enable single sign-on (SSO) for its Informatica MDM users, allowing them to authenticate using their corporate Active Directory credentials instead of maintaining separate MDM-native logins. Which component must be configured in the Hub Console to facilitate this integration?

An LDAP Authentication Provider within the Security Access Manager. (Correct answer)
A Services Integration Framework (SIF) API with a security payload.
A custom cleanse function to validate user credentials.
A new 'Users and Groups' profile with a security token.

Correct answer: An LDAP Authentication Provider within the Security Access Manager.

Informatica MDM integrates with external user directories like LDAP (Lightweight Directory Access Protocol) or Active Directory for user authentication. To achieve this, an administrator must configure an external authentication provider, specifically an LDAP login module, within the Security Access Manager in the Hub Console. This configuration points the MDM Hub to the external directory service for validating user credentials.

Question 38: A data quality rule in Informatica MDM rejects records where the postal code does not match the state. What type of validation is this?

Format validation
Uniqueness constraint
Cross-field validation (Correct answer)
Completeness check

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 39: Which Informatica MDM capability allows governance teams to define and enforce business rules that flag master records failing quality thresholds for steward review?

Stage Jobs
Audit Manager reports
Informatica Data Quality (IDQ) integration with validation rules (Correct answer)
Hierarchy Manager relationship rules

Correct answer: Informatica Data Quality (IDQ) integration with validation rules

Integration with Informatica Data Quality allows governance teams to define validation rules that flag non-compliant master records, routing them to stewards for remediation.

Question 40: What is the primary purpose of the Trust Framework in Informatica MDM Hub?

To schedule batch jobs for data loading and synchronization
To manage user authentication and role-based authorization
To determine which source system contributes the most reliable data to the golden record (Correct answer)
To encrypt sensitive data during transit between source systems

Correct answer: To determine which source system contributes the most reliable data to the golden record

The Trust Framework assigns confidence scores to data from different source systems to determine which values should survive into the golden (best version of truth) record.

Question 41: In a DACI governance model applied to MDM, what does the 'C' (Consulted) role represent?

Those who are notified after a decision is made
Stakeholders whose input is sought before a data governance decision is made (Correct answer)
The individual accountable for overall MDM program success
The person who makes the final data governance decision

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 42: In MDM governance, what is the purpose of a 'data stewardship escalation path'?

To route duplicate match alerts to external data quality vendors
To automatically promote junior stewards to senior roles after a set period
To increase the priority of batch MDM jobs during peak hours
To define the sequence of escalation when a data issue cannot be resolved at a lower stewardship level, ensuring accountability up to executive sponsors (Correct answer)

Correct answer: To define the sequence of escalation when a data issue cannot be resolved at a lower stewardship level, ensuring accountability up to executive sponsors

An escalation path defines how unresolved data issues move up through stewardship levels to governance councils or executive sponsors when lower-level resolution fails.

Question 43: When a hierarchy relationship record has both 'Start Date' and 'End Date' populated, what MDM hierarchy feature is being utilized?

Relationship version control
Soft-delete flagging
Archival hierarchy snapshotting
Temporal or time-variant hierarchy modeling (Correct answer)

Correct answer: Temporal or time-variant hierarchy modeling

Populating start and end dates on relationship records enables temporal hierarchy modeling, allowing the system to represent how organizational structures change over time.

Question 44: When a workflow in MDM Hub is set to 'Auto-Accept,' what happens when all configured business rules pass validation?

The record is flagged for data steward notification only
The record is placed in a pending queue for manual review
The workflow pauses and waits for a scheduled batch job
The record is automatically promoted to the Active state without human intervention (Correct answer)

Correct answer: The record is automatically promoted to the Active state without human intervention

Auto-Accept bypasses the manual approval step and promotes the record directly to Active state when all validation rules are satisfied.

Question 45: When multiple source systems contribute the same field during consolidation in Informatica MDM, how does the Hub resolve the winning value?

The most recently loaded record always wins by default
The value with the highest trust score is selected for the golden record (Correct answer)
A random selection is made among records with equal timestamps
The source system with the highest configured priority number always wins

Correct answer: The value with the highest trust score is selected for the golden record

During consolidation, the MDM Hub selects the field value with the highest trust score to contribute to the golden (best version of truth) record.

Question 46: In MDM Hub, what is the primary function of the 'Tokenize' batch job?

To encrypt sensitive fields in the base object before storage
To assign unique row IDs to incoming landing records
To purge expired cross-reference records from the Hub Store
To generate match tokens (standardized keys) from staging records used in the match process (Correct answer)

Correct answer: To generate match tokens (standardized keys) from staging records used in the match process

The Tokenize job creates standardized match tokens from staging data so the Match job can efficiently compare records using indexed key lookups.

Question 47: Which Informatica MDM staging table stores the raw source data before any cleansing or standardization is applied?

_XREF table
_BO table
_HIST table
_STG table (Correct answer)

Correct answer: _STG table

The _STG (staging) table holds the raw inbound source records exactly as they arrive, prior to any transformation or cleanse processing.

Question 48: An organization wants to synchronize MDM golden records with a Salesforce CRM in near-real-time. Which Informatica capability is best suited for this integration?

Informatica Cloud Data Integration (IICS) with MDM SaaS connector (Correct answer)
Manual export from Hub Console to CSV
Informatica PowerCenter batch ETL
JDBC direct connection from Salesforce to the Hub database

Correct answer: Informatica Cloud Data Integration (IICS) with MDM SaaS connector

Informatica Cloud Data Integration (IICS) provides pre-built connectors and real-time synchronization capabilities between MDM and cloud applications like Salesforce.

Question 49: In Informatica MDM, which scenario would trigger a reject during the load job rather than the stage job?

A record with an unrecognized source system ID
A record with a null required field from the source
A record whose date field cannot be parsed
A record that violates a uniqueness constraint defined on the base object (Correct answer)

Correct answer: A record that violates a uniqueness constraint defined on the base object

Base object-level uniqueness constraint violations are detected at load time when MDM attempts to insert the record into the hub, not at the earlier stage validation phase.

Question 50: A data steward is configuring a match rule and wants to ensure that two records are automatically merged only if their Social Security Numbers (SSN) are identical. For all other potential matches, a manual review is required. Which of the following configurations would achieve this?

A Match Rule Set with a 'Typical' search level.
A single Fuzzy Match rule on the SSN column set to 'Auto Merge'.
A Merge Rule that prioritizes the most recently updated record.
A single Exact Match rule on the SSN column with the 'Auto' property enabled. (Correct answer)

Correct answer: A single Exact Match rule on the SSN column with the 'Auto' property enabled.

An Exact Match rule ensures that only records with identical values in the specified column (SSN) are considered a match. Enabling the 'Auto' property for this specific rule instructs the Auto Merge batch job to automatically merge the records that satisfy this rule, while other matches would be queued for manual review.

Question 51: What is the primary purpose of data integration in MDM?

To delete duplicate records.
To store data temporarily.
To archive legacy data.
To combine and consolidate data from multiple systems (Correct answer)

Correct answer: To combine and consolidate data from multiple systems

The primary purpose of data integration in MDM is to combine and consolidate master data from various disparate source systems into a single, unified, and accurate view. This process eliminates data silos, resolves inconsistencies, and creates a 'golden record' for each master data entity, ensuring all business applications operate with the same reliable information.

Question 52: In Informatica MDM, which tool is used by administrators to configure roles, assign users, and set privileges?

Hub Console Security Manager (Correct answer)
MDM Provisioning Tool
Data Director Admin UI
ActiveVOS Console

Correct answer: Hub Console Security Manager

The Hub Console's Security Manager is the administrative interface where MDM administrators define roles, assign users to roles, and configure resource privileges.

Question 53: In an Informatica MDM hub schema, what distinguishes a 'many-to-many' relationship table from a standard base object?

It holds historical versions of merged records
It stores denormalized data for reporting
It manages associations between two base objects without creating a new master entity (Correct answer)
It contains metadata about system configurations

Correct answer: It manages associations between two base objects without creating a new master entity

A many-to-many relationship table in MDM Hub links two base objects (e.g., Person and Organization) to represent associations without creating a standalone master entity.

Question 54: When a workflow is configured to create a merge task, a data steward claims the task in their inbox. Which tool is primarily used by the data steward to review the matched records side-by-side, view trust scores, and execute the merge or reject the task?

Informatica Data Director (IDD) / Entity 360 (E360) UI (Correct answer)
ActiveVOS Console - Monitor
Provisioning Tool - Application Editor
Hub Console - Data Manager

Correct answer: Informatica Data Director (IDD) / Entity 360 (E360) UI

The Informatica Data Director (IDD) or its modern interface, Entity 360 (E360), is the web-based data governance application designed for business users and data stewards. It provides the user-friendly interface for managing tasks, reviewing potential matches, comparing record details, and making stewardship decisions like merging or unmerging records. [20, 11, 14]

Question 55: Which Informatica MDM feature enables an organization to maintain separate 'views' of a golden record for different consuming applications without changing the underlying master data?

Hierarchy Manager profiles
Base object partitioning
Staging table aliases
Data Views or Subject Area configurations (Correct answer)

Correct answer: Data Views or Subject Area configurations

Subject Areas and data views allow different subsets or presentations of the golden record to be exposed to different consumers without altering the underlying base object data.

Question 56: In Informatica MDM, what is a 'survivorship rule' and when is it applied?

A rule that determines which source system's value survives when the golden record is assembled after a merge (Correct answer)
A rule that controls which match columns are evaluated first in the rule set
A rule that purges records older than a configurable retention period
A rule that governs how match tokens are regenerated after a source record update

Correct answer: A rule that determines which source system's value survives when the golden record is assembled after a merge

Survivorship rules (part of trust configuration) determine which source system cell value 'wins' and is written to the golden record when records from multiple sources are merged.

Question 57: A company uses Informatica MDM for customer data and wants changes to golden records to trigger updates in a downstream data warehouse within minutes. Which approach achieves this?

Have the warehouse directly query the MDM base object tables via JDBC every hour
Configure MDM publication events to a message queue consumed by the warehouse ETL in near-real-time (Correct answer)
Run the full consolidation batch job every night and reload the warehouse daily
Export golden records to a shared file system and let the warehouse pick them up on a schedule

Correct answer: Configure MDM publication events to a message queue consumed by the warehouse ETL in near-real-time

Publishing golden record change events to a message queue allows the warehouse ETL to consume updates within minutes, achieving near-real-time synchronization.

Question 58: In Informatica MDM, what is the effect of granting a role the EXECUTE privilege on a Cleanse function?

The role can invoke the cleanse function via API calls (Correct answer)
The role gains access to all records processed by that function
The role can run data quality cleansing on records
The role can modify the cleanse function definition

Correct answer: The role can invoke the cleanse function via API calls

The EXECUTE privilege on a cleanse function allows the assigned role to invoke that function through API or batch operations.

Question 59: When configuring a source system integration in Informatica MDM, what does 'rowid_object' represent?

The MDM Hub's internal unique identifier for each base object record (Correct answer)
The sequence number used to order batch loads
The hash value generated during the tokenization process
The primary key assigned by the source system to each record

Correct answer: The MDM Hub's internal unique identifier for each base object record

ROWID_OBJECT is the MDM Hub's system-generated unique identifier for each record in a base object, used internally for cross-referencing and relationship management.

Question 60: Which Informatica MDM governance mechanism prevents a source system from overwriting a steward-approved value with a lower-quality incoming update?

Manual override and trust score locking on specific attributes (Correct answer)
Reject table routing for all updates from that source
Setting the base object to read-only mode
Disabling the source system's landing table feed

Correct answer: Manual override and trust score locking on specific attributes

Stewards can manually lock specific attribute values in the golden record, preventing lower-trust source updates from overwriting curated, approved data.

Informatica Master Data Management (MDM) Certification

Certifies proficiency in implementing, configuring, and managing Informatica MDM solutions for data governance and master data management.

Questions

90 min

Time Limit

65%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds