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

Question 1: What is the purpose of 'match columns' in the MDM Hub match configuration?

They define which columns are displayed in the Merge Manager UI
They configure which fields are subject to trust-based survivorship
They determine the column order in landing table loads
They specify which base object fields are used for comparison during the match process and how they are weighted (Correct answer)

Correct answer: They specify which base object fields are used for comparison during the match process and how they are weighted

Match columns define which base object fields participate in the match comparison and assign match strategies and weights to each field, driving the overall match score calculation.

Question 2: 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 compare match scores between consecutive MDM runs
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

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 3: What governance challenge does 'party data' management address in MDM, particularly for financial services organizations?

Managing product catalog hierarchies across subsidiaries
Managing employee payroll data across multiple HR systems
Maintaining a single, consistent view of customers, counterparties, and legal entities to support KYC, AML, and regulatory compliance (Correct answer)
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 4: Which concept describes the process of linking related master data entities across different domains in Informatica MDM?

Hierarchy management
Survivorship
Relationship management (Correct answer)
Cross-referencing

Correct answer: Relationship management

Relationship management in Informatica MDM defines and manages links between entities such as Person-to-Organization or Product-to-Category.

Question 5: Which MDM Hub feature allows a data steward to view a complete history of state changes and actions taken on a workflow task?

Audit Manager
Task History panel in Data Director (Correct answer)
Hub Console Event Log
ORS Change Tracking table

Correct answer: Task History panel in Data Director

The Task History panel in Informatica Data Director (IDD) displays a chronological log of all actions, state changes, and comments for a given task.

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

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

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 7: When configuring a source system in Informatica MDM Hub Console, which setting determines the default trust level assigned to records from that source during load?

Source system trust settings (Correct answer)
Batch group execution order
Cleanse function mapping
Landing table schema definition

Correct answer: Source system trust settings

Trust settings defined per source system establish the baseline confidence score MDM assigns to each attribute from that source, influencing survivorship decisions during load.

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

It converts unmerged clusters into consolidated golden records
It elevates a pending record to be the system-of-record winner
It applies trust decay rules to aging records
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 9: Which Informatica MDM feature enables organizations to enforce data governance policies by restricting which source systems can update specific master record attributes?

IDD Role-Based Access Control
Trust and Validation Rules with Source System Ranking (Correct answer)
Hierarchy Manager
ActiveVOS Task Assignment

Correct answer: Trust and Validation Rules with Source System Ranking

Trust rules combined with source system ranking enforce governance policies by controlling which systems have authority to update specific master record attributes.

Question 10: In Informatica MDM, which merge style produces a single 'golden record' by applying cell-level trust rules across all contributing source records?

Trust-based (best-of-breed) merge (Correct answer)
Last-write-wins merge
Manual merge
Source System Override merge

Correct answer: Trust-based (best-of-breed) merge

Trust-based (best-of-breed) merge evaluates trust scores for each cell across all cross-references and selects the highest-trust value for each attribute in the golden record.

Question 11: Which MDM Hub architectural pattern is used when integrating real-time transactional systems that need immediate master data lookup or updates?

ORS replication via database triggers
SIF (Services Integration Framework) real-time API pattern (Correct answer)
Hierarchy Manager publish-subscribe pattern
Batch ETL pattern using landing tables and staged loads

Correct answer: SIF (Services Integration Framework) real-time API pattern

The SIF real-time API pattern allows transactional systems to query and update master data synchronously via web services, supporting latency-sensitive integration scenarios.

Question 12: 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 encrypt sensitive data during transit between source systems
To determine which source system contributes the most reliable data to the golden record (Correct answer)

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 13: In Informatica MDM, which tool is used by administrators to configure roles, assign users, and set privileges?

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

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 14: 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)
Caching match scores to speed up repeated match operations
Storing archived golden records for historical reporting
Holding rejected records pending manual data steward review

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 15: In Informatica MDM's workflow system, what is the difference between a 'claim' and an 'assignment' for a task?

Claim means a steward voluntarily takes a pooled task; assignment means a manager or system explicitly routes it to a specific steward (Correct answer)
Claim means the system assigns the task; assignment means a steward picks it up voluntarily
Claim permanently locks the task; assignment allows other stewards to override
There is no difference; the terms are interchangeable

Correct answer: Claim means a steward voluntarily takes a pooled task; assignment means a manager or system explicitly routes it to a specific steward

Claiming lets a steward pull a task from a shared pool, while assignment is when the system or a manager explicitly routes the task to a named individual.

Question 16: In the MDM Hub data architecture, what is the role of the 'Pending' state (CONSOLIDATION_IND = 'N') for a base object record?

The record has been loaded to staging but not yet processed through match and consolidation (Correct answer)
The record has been manually edited by a steward and awaits re-matching
The record has failed cleansing and is queued for error correction
The record has been matched but the merge is awaiting steward approval

Correct answer: The record has been loaded to staging but not yet processed through match and consolidation

A CONSOLIDATION_IND value of 'N' (or equivalent pending state) indicates the record exists in the base object but has not yet completed the match and consolidation batch processing cycle.

Question 17: A steward notices that a workflow task has been in the 'Pending' state for 10 days with no action. Which MDM configuration would have automatically escalated this task to a supervisor after 3 days?

Match threshold decay
Trust score expiry rule
Workflow deadline timer with escalation action (Correct answer)
Batch recurrence schedule

Correct answer: Workflow deadline timer with escalation action

A workflow deadline timer configured with an escalation action automatically triggers reassignment or notification when a task exceeds the allowed inactivity period.

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

Reduce the trust score of all source systems to allow more records to be considered for matching
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
Add more staging tables to distribute the load across multiple batch processes

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 19: In Informatica MDM, which setting controls whether a source system's data can replace an existing golden record value regardless of comparative trust scores?

Base Trust
Max Trust
Validation Trust
Override (Correct answer)

Correct answer: Override

The Override setting determines whether a source system's data can replace an existing golden record value regardless of the relative trust scores between competing sources.

Question 20: In MDM Hub's data integration, what is the significance of the 'hub state indicator' (HUB_STATE_IND) column on a base object record?

It stores the geographic region code of the source system that provided the record
It indicates the consolidation state of the record, such as pending merge or active golden record (Correct answer)
It records whether a record was loaded via batch or real-time API
It flags whether the record passed or failed validation checks

Correct answer: It indicates the consolidation state of the record, such as pending merge or active golden record

HUB_STATE_IND tracks the processing state of a record within the MDM Hub, indicating whether it is active, pending consolidation, or in another workflow state.

Question 21: In a data governance framework layered on top of Informatica MDM, what is the primary purpose of a data glossary?

To list all MDM Hub table names and their column data types
To document the ETL mapping logic for each source system feed
To store match token algorithms for each base object
To provide agreed-upon business definitions for data elements used in MDM entities (Correct answer)

Correct answer: To provide agreed-upon business definitions for data elements used in MDM entities

A data glossary captures business-agreed definitions, ownership, and context for data terms, ensuring consistent understanding across teams using MDM.

Question 22: A downstream application requires programmatic, read-only access to customer data via a specific Services Integration Framework (SIF) API. To adhere to the principle of least privilege, what is the best practice for granting this access?

Create a new dedicated role, grant it 'Execute' privilege ONLY on the required SIF API secure resource, and assign a dedicated application user to that role. (Correct answer)
Disable security for all SIF API calls in the Hub Server properties.
Give the application a direct database connection string to the Operational Reference Store (ORS).
Provide the application with the credentials of a 'Data Steward' role.

Correct answer: Create a new dedicated role, grant it 'Execute' privilege ONLY on the required SIF API secure resource, and assign a dedicated application user to that role.

The most secure method that follows the principle of least privilege is to create a specific role for the application. This role should be granted the 'Execute' privilege exclusively for the specific SIF API it needs to call. This ensures the application can only perform its intended function and cannot access other APIs or data. Using a broad role like 'Data Steward', disabling security, or bypassing the application layer with direct database access are all insecure practices.

Question 23: When multiple source systems provide the same entity (e.g., a customer), Informatica MDM creates one golden record. What mechanism links the golden record back to all contributing source records?

The XREF (cross-reference) table (Correct answer)
The base object partition key
The match token index
The staging table's system_name column

Correct answer: The XREF (cross-reference) table

The XREF table stores the cross-references between each golden record's ROWID_OBJECT and the source system records that contributed to it, preserving full data lineage.

Question 24: 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 match rule set last modified in the Hub Console takes precedence
The last batch job to run determines which cross-reference wins
The golden record is always populated from the source system with the most recent record update timestamp (Correct answer)

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 25: Which Informatica MDM component provides a workflow engine for automating data stewardship tasks?

Hierarchy Manager
Data Director
MDM Hub Console
ActiveVOS (Correct answer)

Correct answer: ActiveVOS

ActiveVOS is the embedded workflow engine in Informatica MDM that automates data stewardship tasks such as approval workflows and notifications.

Question 26: Which method reduces latency during data synchronization?

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

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 27: 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 custom cleanse function to validate user credentials.
A Services Integration Framework (SIF) API with a security payload.
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 28: Which SIF API is used to programmatically accept or reject a task in the MDM Hub Data Steward workflow?

UpdateTask (Correct answer)
CompleteTask
AssignTask
ProcessBatch

Correct answer: UpdateTask

UpdateTask allows programmatic resolution of workflow tasks by setting their status to accepted, rejected, or other workflow states.

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

Publication (Correct answer)
Profiling
Tokenization
Validation

Correct answer: Publication

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

Question 30: In Informatica MDM, what does the term 'initial load' specifically refer to in the context of staging and loading?

Loading only the highest-priority source system before others are onboarded
A test load using synthetic data to validate mappings
The first incremental load after a system outage
The first-time full population of the hub from all source systems (Correct answer)

Correct answer: The first-time full population of the hub from all source systems

An initial load is the first end-to-end full load of all source data into a newly configured MDM hub, establishing the baseline set of records from which incremental loads continue.

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

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

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 32: In Informatica MDM, what is the effect of granting a role the EXECUTE privilege on a Cleanse function?

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

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 33: When configuring mappings for a landing table to staging table transition in Informatica MDM, which field mapping is mandatory to enable proper delta detection?

CONSOLIDATION_IND (merge status)
PKEY_SRC_OBJECT (source primary key) (Correct answer)
HUB_STATE_IND (processing state)
ROWID_OBJECT (MDM surrogate key)

Correct answer: PKEY_SRC_OBJECT (source primary key)

PKEY_SRC_OBJECT must be mapped because it carries the source system's primary key, which MDM uses during delta detection to compare incoming records against previously staged data.

Question 34: A governance committee wants to track who approved a merge of two customer records in Informatica MDM. Which capability provides this audit trail?

Hierarchy Manager lineage view
Schema Manager version control
MDM Hub audit logging and history tables (Correct answer)
Batch Viewer job log

Correct answer: MDM Hub audit logging and history tables

MDM Hub maintains audit logs and history tables (e.g., _HIST tables) that record every change, approval, and merge action along with the user who performed it.

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

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

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 36: What is the role of the 'delta detection' feature in MDM Hub's staging process?

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

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 37: Which of the following best defines data quality?

The amount of data collected.
The rate of data deletion.
The usability and accuracy of data (Correct answer)
How often data is accessed.

Correct answer: The usability and accuracy of data

Data quality refers to the overall fitness of data for its intended purpose. It encompasses characteristics like accuracy, completeness, consistency, timeliness, and validity. High-quality data is reliable, usable, and essential for effective business operations and informed decision-making.

Question 38: In Informatica MDM Hub, what is the purpose of 'cleanse functions' applied during the Stage process?

Standardizing and normalizing source data values before matching and consolidation (Correct answer)
Converting base object records to JSON format for API publishing
Removing records that fail referential integrity checks
Encrypting personally identifiable information at rest

Correct answer: Standardizing and normalizing source data values before matching and consolidation

Cleanse functions standardize source data (e.g., name parsing, address normalization) during staging so that the match engine can accurately identify duplicates.

Question 39: Which of these supports automated data synchronization?

Spreadsheet macros.
Middleware tools like Mulesoft (Correct answer)
Manual database queries.
Text-based scripts only.

Correct answer: Middleware tools like Mulesoft

Middleware tools like Mulesoft are designed to support automated data synchronization by acting as an intermediary between different applications and systems. They provide capabilities for API management, data transformation, message queuing, and orchestration, enabling seamless and automated data flow. This reduces manual effort and improves the efficiency and reliability of synchronization processes.

Question 40: In Informatica MDM Hub, what is the 'Hub Console' primarily used for?

Executing SIF API calls to read and write master data
Providing a web-based administration interface for configuring all hub components (Correct answer)
Monitoring real-time data streaming into the hub
Running batch load and match jobs via command line

Correct answer: Providing a web-based administration interface for configuring all hub components

The Hub Console is the web-based administrative GUI used to configure all MDM Hub components including schema, match rules, trust settings, and security.

Question 41: During Informatica MDM real-time match (SIF ExecuteMatchAndMerge), which match rule sets are evaluated?

Only rule sets that have the 'Enable Real-Time Match' flag set to true (Correct answer)
All rule sets regardless of their 'Enable Real-Time Match' setting
Only the rule set with the highest priority number
Only exact-match rule sets; fuzzy rule sets are skipped in real-time

Correct answer: Only rule sets that have the 'Enable Real-Time Match' flag set to true

Only match rule sets explicitly configured with 'Enable Real-Time Match' set to true are evaluated during real-time SIF match operations.

Question 42: What is a data quality dashboard?

A tool for writing business emails.
A chart for employee evaluations.
A summary of internet traffic.
A visual interface displaying data quality indicators (Correct answer)

Correct answer: A visual interface displaying data quality indicators

A data quality dashboard provides a visual, real-time overview of an organization's data quality status. It displays key data quality indicators (DQIs) such as completeness, accuracy, consistency, and validity, often using charts and graphs. This tool helps stakeholders quickly identify data issues, monitor improvement efforts, and make informed decisions about data management.

Question 43: In Informatica MDM, which workflow trigger type initiates a process automatically when a record reaches a specific state in the state machine?

Event-based trigger (Correct answer)
Scheduled trigger
Manual trigger
API trigger

Correct answer: Event-based trigger

Event-based triggers fire automatically when a record transitions to a defined state, enabling straight-through processing without human intervention.

Question 44: An MDM architect needs to integrate a real-time POS system that sends individual transaction records every second. Which integration approach is most appropriate?

SIF (Services Integration Framework) API calls for real-time record processing (Correct answer)
Nightly batch file load via PowerCenter ETL
Manual CSV import through the Hub Console
Scheduled polling of the POS database every hour

Correct answer: SIF (Services Integration Framework) API calls for real-time record processing

The Services Integration Framework (SIF) API enables real-time, record-by-record integration suitable for high-frequency transaction sources like POS systems.

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

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

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 46: Which Informatica MDM batch job must be executed to promote staged records through match, merge, and consolidation?

Consolidate job (Correct answer)
Tokenize job
Publish job
Load job

Correct answer: Consolidate job

The Consolidate (or Match and Merge) batch job processes staged records through match rules, identifies duplicates, and merges them into golden records.

Question 47: What is the effect of setting 'Reject Null Values' on a base object column in Informatica MDM during the load process?

Records with nulls in that column are automatically assigned a default value
Records with nulls in that column are rejected and written to the error table (Correct answer)
The load job skips null fields and only updates populated attributes
Null values are replaced by the value from the previous successful load

Correct answer: Records with nulls in that column are rejected and written to the error table

When 'Reject Null Values' is enabled for a column, any incoming record containing null in that field is rejected at load time and placed in the error/reject table.

Question 48: 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 single Exact Match rule on the SSN column with the 'Auto' property enabled. (Correct answer)
A single Fuzzy Match rule on the SSN column set to 'Auto Merge'.
A Merge Rule that prioritizes the most recently updated record.
A Match Rule Set with a 'Typical' search level.

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 49: A data steward can edit records in MDM Data Director but cannot delete them. Which privilege configuration explains this?

The role is missing the MERGE privilege
The role has UPDATE but not DELETE privilege on the relevant base objects (Correct answer)
The role needs the PROMOTE privilege to enable deletions
DELETE is always disabled in Data Director by default

Correct answer: The role has UPDATE but not DELETE privilege on the relevant base objects

In MDM Hub, UPDATE and DELETE are separate privileges on base objects, so a role can be granted UPDATE without DELETE to allow editing but not removal.

Question 50: In Informatica MDM, a source system has Base Trust = 55 and Validation Trust = 25. If Max Trust is set to 70, what is the effective maximum trust score achievable?

55
70 (Correct answer)
25
80

Correct answer: 70

Even though Base Trust + Validation Trust = 80, the Max Trust of 70 acts as an absolute ceiling, capping the effective trust score at 70.

Question 51: What happens in SIF when a 'PutRecord' call attempts to insert a record that already exists with the same primary key?

It creates a second record with an auto-generated surrogate key
It performs an upsert, updating the existing record with the new field values (Correct answer)
It throws a duplicate key exception and rolls back the transaction
It ignores the call and returns the existing record unchanged

Correct answer: It performs an upsert, updating the existing record with the new field values

PutRecord performs an upsert operation, inserting a new record or updating the existing one if the primary key already exists.

Question 52: In Informatica MDM, which security model controls access at the individual record level rather than the object level?

Object-level security
Column-level security
Field-level security
Row-level security (Correct answer)

Correct answer: Row-level security

Row-level security in Informatica MDM restricts which records a user can view or modify based on data values or organizational hierarchy.

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

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

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 54: Which approach ensures consistent data synchronization between systems?

Synchronous communication and real-time updates (Correct answer)
Isolated databases.
Manual data entry.
Batch processing only.

Correct answer: Synchronous communication and real-time updates

To ensure consistent data synchronization between systems, synchronous communication and real-time updates are essential. This approach means that changes made in one system are immediately propagated and reflected in all connected systems. Real-time updates minimize data latency and ensure that all applications are operating with the most current and accurate master data.

Question 55: In the MDM Hub Schema Manager, at which point are trust settings typically assigned to base object columns?

During the initial Hub Store database installation
When configuring base objects and defining source system contributions (Correct answer)
Automatically by the MDM Hub without requiring manual configuration
Only after the first full batch load has been completed

Correct answer: When configuring base objects and defining source system contributions

Trust settings are configured in the Schema Manager when setting up base objects and defining how each source system contributes to each column, as part of schema design.

Question 56: Which Informatica MDM batch job must be run before the 'Match' job to ensure match key tables are populated?

Publish
Consolidate
Tokenize (Correct answer)
Load

Correct answer: Tokenize

The Tokenize batch job must run first to generate and store match key tokens in the match token tables (_MTT); the Match job then uses those tokens to retrieve candidates.

Question 57: What role does a data steward play?

Creating software applications.
Managing IT infrastructure.
Developing marketing campaigns.
Enforcing data governance policies (Correct answer)

Correct answer: Enforcing data governance policies

A data steward is a key role within a data governance framework, responsible for the practical implementation and enforcement of data governance policies. They ensure data quality, manage data definitions, resolve data issues, and act as a liaison between data users and IT. Their work is crucial for maintaining the integrity and usability of data assets.

Question 58: What is the valid range for trust scores in Informatica MDM Hub?

0 to 50
-100 to 100
0 to 100 (Correct answer)
1 to 10

Correct answer: 0 to 100

Trust scores in Informatica MDM range from 0 to 100, where 100 represents maximum confidence and 0 represents no confidence in the data value.

Question 59: How are hierarchy relationships validated in MDM?

By using validation rules and constraints (Correct answer)
By executing SQL queries manually.
By restarting the repository server.
By deleting invalid records.

Correct answer: By using validation rules and constraints

Hierarchy relationships in MDM are validated by applying predefined validation rules and constraints. These rules ensure that the relationships adhere to business logic, data integrity standards, and structural requirements (e.g., preventing circular references or ensuring parent-child relationships are correctly formed). This proactive validation maintains the accuracy and consistency of the hierarchical data model.

Question 60: What is the primary advantage of the Trust Framework over a simple 'last-write-wins' survivorship strategy in Informatica MDM?

It eliminates the need for human data stewardship entirely
It automatically synchronizes the golden record back to all source systems in real time
It reduces storage requirements for master data in the Hub Store
It allows multiple source systems to contribute field values based on their configured reliability (Correct answer)

Correct answer: It allows multiple source systems to contribute field values based on their configured reliability

The Trust Framework enables field-level survivorship based on each source system's reliability configuration, ensuring the most trustworthy data from any contributing source wins rather than always defaulting to the most recent update.

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