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

Question 1: In Informatica MDM, what does 'pending merge' status indicate for a record pair?

The records are queued for the next batch consolidation run but have not yet been matched
The match process identified the records as potential duplicates, but a data steward must review and approve the merge (Correct answer)
The records failed cleansing and are pending re-submission from the source system
The records have been auto-merged but are awaiting publication to downstream systems

Correct answer: The match process identified the records as potential duplicates, but a data steward must review and approve the merge

Pending merge status means the match engine flagged a record pair as probable duplicates within a configurable threshold, requiring human review before the merge is executed.

Question 2: In Informatica MDM, what is the governance significance of the 'Hub State Indicator' (HUB_STATE_IND) column on a base object record?

It identifies which batch job last updated the record
It stores the trust score of the source system that contributed the record
It indicates whether the record is active, merged into another record, or marked as deleted, controlling its visibility in queries (Correct answer)
It flags whether the record has passed all data quality checks

Correct answer: It indicates whether the record is active, merged into another record, or marked as deleted, controlling its visibility in queries

HUB_STATE_IND governs the lifecycle state of a base object record—active (1), merged-away (0), or deleted—determining whether it participates in MDM operations.

Question 3: Which method reduces latency during data synchronization?

Real-time data streaming (Correct answer)
Email notifications.
Manual synchronization.
Physical data storage.

Correct answer: Real-time data streaming

Real-time data streaming is a method that significantly reduces latency during data synchronization. Instead of processing data in batches, real-time streaming processes data as it is generated or updated, allowing for immediate propagation of changes across systems. This ensures that all applications have access to the most current information with minimal delay.

Question 4: In SIF, what is the significance of the 'consolidation_ind' field on a cross-reference (XREF) record?

It flags duplicate cross-references for cleansing
It indicates whether the cross-reference record's data has been promoted to the golden record (Correct answer)
It controls whether the source record is visible in search results
It marks the record as the primary system of record for the golden record

Correct answer: It indicates whether the cross-reference record's data has been promoted to the golden record

The consolidation_ind flag on an XREF record shows whether that source contribution has been consolidated into the best version of truth.

Question 5: Which load type in Informatica MDM replaces all existing hub records with incoming source data, regardless of changes?

Full load (Correct answer)
Delta load
Merge load
Incremental load

Correct answer: Full load

A full load truncates or overwrites existing data and reloads everything from the source, useful for initial loads or complete refreshes.

Question 6: A workflow task is configured with 'Reviewer' and 'Approver' roles. In which order are these roles typically invoked in a standard multi-step approval workflow?

Approver first, then Reviewer
Both roles are notified simultaneously
Reviewer first, then Approver (Correct answer)
Order is determined by record priority only

Correct answer: Reviewer first, then Approver

In a standard multi-step workflow, Reviewers evaluate changes first and, upon acceptance, the task advances to Approvers for final sign-off.

Question 7: An MDM project team observes that match rates are very low despite obvious duplicates existing in the source data. Which corrective action should be investigated first?

Add more staging tables to distribute the load across multiple batch processes
Review and improve the cleanse functions and match rule configurations, including token generation and match column weights (Correct answer)
Increase the Hub Server JVM heap size to allow more records in memory during matching
Reduce the trust score of all source systems to allow more records to be considered for matching

Correct answer: Review and improve the cleanse functions and match rule configurations, including token generation and match column weights

Low match rates typically indicate that cleanse functions are not standardizing data adequately or that match rules and token configurations are not aligned with the actual data patterns.

Question 8: A governance policy requires that changes to supplier master records be approved by at least two stewards. Which Informatica MDM feature supports this requirement?

Multi-step task workflow with sequential approvals in Data Director (Correct answer)
Schema Manager role-based column masking
Batch job chaining with approval flags in the Batch Viewer
Dual-source trust scoring with override locking

Correct answer: Multi-step task workflow with sequential approvals in Data Director

MDM Hub's task workflow engine in Data Director can be configured with multi-step, multi-approver sequences to enforce dual-approval governance policies.

Question 9: What is the purpose of the 'delta detection' step in Informatica MDM's load process?

To flag records that have been manually edited by data stewards
To identify new or changed source records since the last load, avoiding reprocessing of unchanged data (Correct answer)
To detect data quality errors before records enter the staging table
To compare match scores between consecutive MDM runs

Correct answer: To identify new or changed source records since the last load, avoiding reprocessing of unchanged data

Delta detection compares incoming source records against the previous load to identify only new or changed records, improving load efficiency.

Question 10: What is the role of the 'delta detection' feature in MDM Hub's staging process?

It measures the difference in trust scores between two competing source systems
It detects mismatches between landing and staging column mappings before data is processed
It compares match scores between successive job runs to flag configuration drift
It identifies and processes only records that have changed since the last load, reducing processing overhead (Correct answer)

Correct answer: It identifies and processes only records that have changed since the last load, reducing processing overhead

Delta detection compares incoming landing records against previously staged data and skips unchanged records, significantly improving incremental load performance.

Question 11: When configuring an Informatica MDM merge rule, what does 'Last Updated' survivorship strategy mean?

The most recently merged golden record overwrites all older versions
The golden record is always populated from the source system with the most recent record update timestamp (Correct answer)
The match rule set last modified in the Hub Console takes precedence
The last batch job to run determines which cross-reference wins

Correct answer: The golden record is always populated from the source system with the most recent record update timestamp

The Last Updated survivorship strategy selects the cell value from the cross-reference record that was most recently updated, regardless of which source system it came from.

Question 12: In the context of Informatica MDM data governance, what does 'data lineage' specifically track?

The hierarchy relationships between parent and child entities in the data model
The sequence of batch jobs that processed a record through the MDM pipeline
The list of downstream applications that consume master data via SIF APIs
The origin source system and transformation history of each attribute value in the golden record (Correct answer)

Correct answer: The origin source system and transformation history of each attribute value in the golden record

Data lineage in MDM tracks where each golden record attribute came from, including which source system contributed it and what transformations were applied.

Question 13: In MDM Hub's data model, what distinguishes a 'Relationship Base Object' from a standard base object?

It is used exclusively for hierarchy management
It cannot have trust and survivorship rules applied to it
It stores audit history rather than current master records
It represents many-to-many associations between two base objects using foreign key columns (Correct answer)

Correct answer: It represents many-to-many associations between two base objects using foreign key columns

A Relationship Base Object models many-to-many associations between two entities by storing foreign key references to both related base objects, enabling complex relationship tracking.

Question 14: In MDM Hub, what is the function of the 'delta detection' step during the Stage process?

Identifying records that have changed since the last load to avoid reprocessing unchanged data (Correct answer)
Calculating the statistical difference between two golden records
Detecting mismatches between source schema and Hub schema
Flagging records that exceed the maximum allowed field length

Correct answer: Identifying records that have changed since the last load to avoid reprocessing unchanged data

Delta detection compares incoming source records against previously staged data to identify only the changed records, improving performance by avoiding redundant processing.

Question 15: In Informatica MDM, what does 'unmerge' allow data stewards to do?

Permanently delete a golden record and all its source contributors
Separate previously merged source records back into independent records (Correct answer)
Remove a base object column without affecting existing data
Undo a trust score reconfiguration applied during the last batch run

Correct answer: Separate previously merged source records back into independent records

Unmerge allows data stewards to reverse an incorrect merge by separating the source records that were consolidated into a golden record, creating distinct records again.

Question 16: Which Informatica MDM feature allows a source system to signal that a previously loaded record should be logically removed from the hub during the next load?

Hard delete flag in the base object
Match exclusion rule
Trust decay configuration
Delete indicator on the staging record (Correct answer)

Correct answer: Delete indicator on the staging record

A delete indicator (or HUB_STATE_IND set to indicate deletion) on a staging record tells the load job to logically remove or deactivate the corresponding base object record.

Question 17: Which synchronization pattern does Informatica MDM use when it pushes updated golden records back to subscribing source systems?

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

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 18: In Informatica Data Director, which role typically has permission to configure workflow definitions, whereas a regular data steward only executes them?

MDM Administrator or Business Administrator (Correct answer)
Data Consumer
External Source System Owner
Read-only Analyst

Correct answer: MDM Administrator or Business Administrator

The MDM Administrator or Business Administrator role has privileges to design and modify workflow definitions, while data stewards operate within the workflows as configured.

Question 19: 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 20: In Informatica Data Director, a steward opens a task and sees fields highlighted in different colors representing data from multiple source systems. What feature generates this display?

Trust scoring overlay
Cross-reference view
Survivorship comparison panel (Correct answer)
Lineage graph

Correct answer: Survivorship comparison panel

The survivorship comparison panel highlights contributed field values from each source system so stewards can see which system won for each attribute.

Question 21: 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?

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

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 22: In Informatica MDM, what security consideration applies when using the Bulk Data Manager for large-scale data loads?

Bulk Data Manager encrypts all data in transit automatically
Bulk loads bypass all row-level security and data filters (Correct answer)
Bulk load service accounts must be granted EXECUTE privilege on landing tables
Bulk loads require Admin role to run regardless of data content

Correct answer: Bulk loads bypass all row-level security and data filters

Bulk data operations in MDM Hub typically bypass row-level data filters, so organizations must ensure that bulk load service accounts are tightly restricted and audited.

Question 23: A new Operational Reference Store (ORS) has been created in the database using the `sip_ant.bat create_ors` script. What are the immediate next steps required to make it fully operational within the MDM Hub?

Run the `validate_ors` script and then register it in the Hub Console.
Register the ORS in the Hub Console and then run the `import_ors` script.
Run the `import_ors` script to create system tables and then register the database in the Hub Console. (Correct answer)
Deploy the Hub Server application and then add the ORS connection details.

Correct answer: Run the `import_ors` script to create system tables and then register the database in the Hub Console.

After creating the ORS with `create_ors`, the next crucial step is to run the `import_ors` script. This process creates the necessary system and repository tables within the newly created database schema. Only after the import is successful can the ORS be registered as a database within the Hub Console, making it accessible to the MDM Hub.

Question 24: An organization uses Informatica MDM and wants rejected records to automatically notify the source system via a message queue so the originating application can correct and resubmit the data. Which integration approach enables this?

Manual export from Data Director to CSV
Workflow exit action invoking a JMS or message queue publish event (Correct answer)
Scheduled batch re-extract from the Hub Store
Direct SQL update to the landing table

Correct answer: Workflow exit action invoking a JMS or message queue publish event

A workflow exit action can publish a rejection event to a JMS message queue, enabling the source application to receive the notification and initiate a correction workflow on its end.

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

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

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 26: In Informatica MDM match configuration, what does increasing the 'Match Column Weight' of a column achieve?

It increases the maximum possible match score contribution from that column relative to others (Correct answer)
It disables fuzzy matching and enforces exact comparison for that column
It forces the column to be evaluated first regardless of primary column settings
It requires an exact match on that column before any other columns are scored

Correct answer: It increases the maximum possible match score contribution from that column relative to others

A higher weight for a match column means that column contributes more to the total match score, making it more influential in determining whether two records are duplicates.

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

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

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 28: 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?

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

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 29: Which SIF operation allows external systems to add a new record to a landing table without triggering the match-and-merge process immediately?

PutBvt
Put (to landing table) (Correct answer)
MergeRecords
ExecuteMatchColumns

Correct answer: Put (to landing table)

Putting data into a landing table loads records for staging without immediately invoking the match-and-merge batch process.

Question 30: What feature enables visualization of hierarchy in Informatica MDM?

Repository Manager
Match Path Analyzer
Package Explorer
Hierarchy Viewer (Correct answer)

Correct answer: Hierarchy Viewer

The Hierarchy Viewer is a specific feature within Informatica MDM that enables users to visually explore and understand complex hierarchy relationships. It provides a graphical representation of parent-child structures, allowing users to navigate, analyze, and gain insights into how master data records are interconnected. This visualization is essential for managing and interpreting hierarchical data effectively.

Question 31: What is the maximum number of records typically returned by a single SIF SearchQuery call by default in Informatica MDM Hub?

1000
200 (Correct answer)
500
100

Correct answer: 200

By default, SIF SearchQuery returns up to 200 records, though this limit can be configured in the Hub Server properties.

Question 32: What is an ETL process in data integration?

Erase, Tag, Log.
Extract, Transform, Load (Correct answer)
Enter, Test, Load.
Encrypt, Transmit, Lock.

Correct answer: Extract, Transform, Load

ETL stands for Extract, Transform, Load, which is a widely used process in data integration and data warehousing. It involves extracting data from source systems, transforming it to meet the business requirements and target system format, and then loading it into the destination system. This process is fundamental for consolidating and preparing data for analysis or MDM.

Question 33: How does Informatica MDM handle 'unmerge' operations from a governance perspective?

Unmerge requires direct SQL updates to the base object tables
Unmerge is not supported; once records are merged they cannot be separated
Unmerge automatically runs at midnight during maintenance windows
Stewards can unmerge previously consolidated records through IDD, which restores the original cross-reference links and triggers a governance workflow (Correct answer)

Correct answer: Stewards can unmerge previously consolidated records through IDD, which restores the original cross-reference links and triggers a governance workflow

Informatica MDM supports steward-initiated unmerge through IDD, which separates incorrectly merged records and restores source cross-references via a governed workflow.

Question 34: What is the role of the 'message queue' in Informatica MDM's real-time data integration architecture?

Buffering inbound source updates and outbound golden record publications for asynchronous processing (Correct answer)
Holding rejected records pending manual data steward review
Caching match scores to speed up repeated match operations
Storing archived golden records for historical reporting

Correct answer: Buffering inbound source updates and outbound golden record publications for asynchronous processing

Message queues (such as JMS queues) buffer both inbound source record updates and outbound publication events, enabling asynchronous and decoupled real-time integration.

Question 35: An organization wants to implement a two-step approval process for any updates made to a 'Product' Business Entity. A junior data steward can submit a change, which must then be approved by a senior data steward before the record becomes active. Which components in Informatica MDM are essential to configure this workflow?

Match and Merge rules only.
State Management on the base object and a custom Java cleanse function.
ActiveVOS workflow engine, task types for each approval level, and workflow triggers. (Correct answer)
A message queue and the Services Integration Framework (SIF) APIs.

Correct answer: ActiveVOS workflow engine, task types for each approval level, and workflow triggers.

Implementing multi-step approval workflows requires the ActiveVOS BPM engine integrated with MDM. You need to define different task types for each step in the process (e.g., 'AVOSBeReviewNoApprove', 'AVOSBeFinalReview') and configure workflow triggers that initiate the process when a specific event occurs, such as updating a Product record. [28, 25, 26]

Question 36: What does the consolidation indicator value 'U' represent in a Hub cross-reference record?

Unmerged record awaiting processing (Correct answer)
Undergoing match processing
Updated record pending re-evaluation
Unique record that bypassed matching

Correct answer: Unmerged record awaiting processing

A consolidation indicator of 'U' marks a cross-reference record as unmerged, meaning it has not yet been matched and consolidated into a golden record.

Question 37: What is the recommended approach for securing Informatica MDM SIF web service endpoints exposed to external consumers?

Place MDM SIF endpoints behind an API gateway or reverse proxy with TLS termination and network access controls (Correct answer)
Expose endpoints on the public internet without restriction and rely on MDM login() for security
Disable SIF endpoints and use only file-based integration
Grant external consumers the Admin role to simplify access

Correct answer: Place MDM SIF endpoints behind an API gateway or reverse proxy with TLS termination and network access controls

Best practice is to front MDM SIF endpoints with an API gateway or reverse proxy that enforces TLS, rate limiting, and network-level access controls in addition to MDM's own authentication.

Question 38: What does the term 'survivorship' refer to in Informatica MDM data integration?

A technique for compressing duplicate records in the Hub Store
Rules that determine which source attribute values populate the golden record (Correct answer)
The process of archiving deleted records for audit purposes
The mechanism for routing rejected records to error queues

Correct answer: Rules that determine which source attribute values populate the golden record

Survivorship rules define how the golden record is constructed by selecting the best attribute values from competing source systems based on trust, recency, or custom logic.

Question 39: What does the Informatica MDM 'Unmerge' operation accomplish?

Resets all trust scores to their initial source-system defaults
Moves a record from the base object to a quarantine table
Permanently deletes all cross-reference records associated with a golden record
Separates a previously merged record, restoring contributing records as independent base object entries (Correct answer)

Correct answer: Separates a previously merged record, restoring contributing records as independent base object entries

Unmerge reverses a prior merge by detaching the cross-reference records from the golden record and promoting them back to independent base object records with their own ROWIDs.

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

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

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 41: What does the 'Rowid Object' column represent in an MDM Hub base object table?

The source system's original record key
A unique system-generated identifier for each master record (Correct answer)
A hash value used for change detection
A foreign key referencing the parent base object

Correct answer: A unique system-generated identifier for each master record

The Rowid Object is a system-generated unique identifier assigned to every master record in a base object table within MDM Hub.

Question 42: Which Informatica MDM security practice ensures that service accounts used by ETL processes follow least-privilege principles?

Granting MERGE privilege to enable all data operations
Using shared user credentials for all ETL jobs
Assigning service accounts to the Admin role
Creating dedicated roles with only the specific base object and package privileges needed (Correct answer)

Correct answer: Creating dedicated roles with only the specific base object and package privileges needed

Least-privilege for ETL service accounts means creating custom roles that grant only the specific READ, CREATE, or UPDATE privileges required for those integration processes.

Question 43: Which process in Informatica MDM ensures that updated golden records are automatically reflected in subscribing applications without requiring those applications to query the Hub?

Tokenization
Publication (Correct answer)
Validation
Profiling

Correct answer: Publication

The Publication process pushes updated golden records to downstream subscribers via message queues or services, implementing event-driven synchronization.

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

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

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 45: How does Informatica MDM handle password policies when using internal (non-LDAP) user authentication?

MDM Hub does not support password policies for internal users
Password complexity is configured in the Hub Store ORS
Password policies are defined in the CMX_SYSTEM schema configuration tables
Password policies are enforced by the underlying application server (e.g., JBoss/WebLogic) (Correct answer)

Correct answer: Password policies are enforced by the underlying application server (e.g., JBoss/WebLogic)

When using internal authentication, Informatica MDM relies on the Java EE application server's security realm and its password policy enforcement mechanisms.

Question 46: In Informatica MDM, which governance role is primarily responsible for defining and enforcing data quality rules for a specific business domain?

System Administrator
Data Steward (Correct answer)
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 47: Which Informatica MDM capability allows governance teams to define and enforce business rules that flag master records failing quality thresholds for steward review?

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

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 48: In the MDM Hub console, what is a 'Package' used for?

To group batch jobs into a scheduled workflow
To bundle and deploy Hub configuration to another environment
To archive older versions of golden records
To define a reusable set of columns returned from a base object for SIF queries (Correct answer)

Correct answer: To define a reusable set of columns returned from a base object for SIF queries

A Package in MDM Hub defines a named subset of columns from a base object that can be queried through the Services Integration Framework (SIF).

Question 49: 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 cap the number of records processed per batch job
To define the maximum trust score a source system can receive
To limit the number of source systems that can write to the staging table

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 50: In Informatica MDM, what is the role of 'trust settings' during survivorship?

They encrypt sensitive attributes in the hub store
They determine how long a record is retained before archival
They define which source system's attribute value is most reliable and should be preferred in the golden record (Correct answer)
They control user access permissions to base objects

Correct answer: They define which source system's attribute value is most reliable and should be preferred in the golden record

Trust settings assign confidence scores to source systems per attribute, guiding survivorship rules to select the most reliable value for the golden record.

Question 51: What is the primary purpose of workflow configuration in MDM?

To define and automate business processes (Correct answer)
To set up user passwords.
To manually cleanse records.
To create database schemas.

Correct answer: To define and automate business processes

In Master Data Management (MDM), workflow configuration is primarily used to define, automate, and manage the sequence of tasks involved in various business processes related to master data. This includes data creation, updates, approvals, and data quality remediation. Automating these processes ensures consistency, efficiency, and adherence to governance policies, streamlining master data management.

Question 52: In Informatica MDM Hub's hub architecture, what is an 'Operational Reference Store' (ORS)?

A staging area external to MDM Hub used by ETL tools
A cache layer that speeds up match processing
A self-contained database schema storing all hub metadata and master data for a domain (Correct answer)
A read-only analytical data warehouse fed by MDM Hub

Correct answer: A self-contained database schema storing all hub metadata and master data for a domain

An ORS is an independent database schema within MDM Hub that contains all metadata configurations, staging objects, and master data records for a specific data domain.

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

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

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 54: When configuring Informatica MDM to use SAML-based single sign-on, which component acts as the service provider?

Identity Resolution Engine
Siperian BPM
MDM Hub Server (Correct answer)
Hub Console

Correct answer: MDM Hub Server

The MDM Hub Server acts as the SAML service provider, relying on an external identity provider to authenticate users before granting access.

Question 55: In Informatica MDM SIF, what does 'EJB transport' mode provide compared to HTTP transport?

Automatic retry logic for failed SIF requests
Lower latency for in-JVM or same-cluster SIF calls by avoiding network serialization overhead (Correct answer)
Support for asynchronous message delivery via JMS
Built-in load balancing across multiple Hub Server nodes

Correct answer: Lower latency for in-JVM or same-cluster SIF calls by avoiding network serialization overhead

EJB transport provides faster in-JVM communication by using direct Enterprise JavaBean calls rather than going over the network stack.

Question 56: Which of the following best describes the relationship between a Base Object, Staging Tables, and source systems in a typical Informatica MDM implementation?

One Base Object can have only one Staging Table, which receives data from a single source system.
A Base Object consolidates data, and there is typically one Staging Table for each source system that contributes data to that Base Object. (Correct answer)
Staging Tables are created from Base Objects to push master data back to source systems.
Multiple Base Objects are mapped to a single Staging Table for data consolidation.

Correct answer: A Base Object consolidates data, and there is typically one Staging Table for each source system that contributes data to that Base Object.

The standard data model architecture involves a central Base Object for the master record. To populate this Base Object, data is first brought into source-specific Staging Tables. Therefore, a single Base Object will have multiple associated Staging Tables, one for each contributing source system.

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?

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

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: 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 59: What is the role of the ROWID_OBJECT column that Informatica MDM assigns during the load process?

It holds the trust-weighted confidence score for each record
It tracks the number of times a record has been merged
It stores the source system's primary key for traceability
It is the unique surrogate key MDM generates for each base object record (Correct answer)

Correct answer: It is the unique surrogate key MDM generates for each base object record

ROWID_OBJECT is the MDM-generated surrogate key that uniquely identifies each record in the base object table, independent of any source system key.

Question 60: In Informatica MDM Hub, the XREF table created during load primarily serves which purpose?

Holds historical versions of records before survivorship
Tracks match rule execution results per record pair
Maps source system keys to MDM surrogate keys for cross-referencing (Correct answer)
Stores consolidated best-version-of-truth attribute values

Correct answer: Maps source system keys to MDM surrogate keys for cross-referencing

The XREF (cross-reference) table links each source system's native key to the corresponding MDM ROWID_OBJECT, enabling traceability back to originating systems.

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