MDM - Informatica Master Data Management Hub Configuration and Management Questions and Answers — Questions and Answers
Question 1: An MDM administrator is tasked with promoting a new, validated data model from the development environment to the production environment. Which tool within the Hub Console is specifically designed for this purpose?
- Schema Viewer
- Repository Manager (Correct answer)
- Data Manager
- Enterprise Manager
Correct answer: Repository Manager
The Repository Manager is the correct tool used for managing and migrating metadata configurations, such as data models, between different Operational Reference Stores (ORS). It allows administrators to compare repositories, generate change lists, and import/export design objects, which is the standard procedure for promoting changes from development to production.
Question 2: 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?
- Register the ORS in the Hub Console and then run the `import_ors` script.
- Run the `validate_ors` script and then register it in the Hub Console.
- 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 3: A business requirement states that whenever a customer's address is updated and consolidated (merged), an XML message containing the new address must be sent to a downstream CRM system in near real-time. Which MDM Hub components must be configured to achieve this?
- Batch Viewer and Batch Group
- Services Integration Framework (SIF) SDK and a custom application
- Cleanse Functions and Mappings
- Message Queues and Message Triggers (Correct answer)
Correct answer: Message Queues and Message Triggers
This scenario requires an event-driven, asynchronous notification to an external system. This is the primary function of JMS Message Queues in Informatica MDM. An administrator would configure an outbound message queue and then set up message triggers on the relevant Base Object (e.g., Customer Address) to publish a message whenever a specific event, like a merge or update, occurs.
Question 4: A data steward reports they are unable to manually merge two matched records using the Merge Manager tool in the Hub Console. The administrator has verified the steward has the correct role and privileges. What is a likely configuration issue preventing the merge?
- The records have not been tokenized by the match process.
- The Trust Framework is not enabled for the Base Object's columns.
- A private resource has been configured on the Base Object, restricting access.
- The Security Access Manager (SAM) has not been configured for the relevant roles. (Correct answer)
Correct answer: The Security Access Manager (SAM) has not been configured for the relevant roles.
The Security Access Manager (SAM) is the component responsible for fine-grained security and access control on MDM resources, including Hub Console tools and processes. Even if a user has a general role, SAM rules define specific privileges, such as the ability to execute merges. If the data steward's role lacks the necessary privileges within SAM for the Merge Manager or the specific package, they will be unable to perform the action.
Question 5: 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
- Base Objects and Staging Tables
- User Accounts, Security Providers, and Message Queue Servers (Correct answer)
- Mappings and Hierarchies
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 6: An administrator is configuring the Hub Server and needs to ensure that asynchronous data access and processing requests can be handled efficiently. Which technology is fundamental for the Hub Server to process these incoming asynchronous requests via the Services Integration Framework (SIF)?
- REST APIs
- Java Database Connectivity (JDBC)
- Java Message Service (JMS) Queues (Correct answer)
- Secure Sockets Layer (SSL)
Correct answer: Java Message Service (JMS) Queues
The Services Integration Framework (SIF) uses Java Message Service (JMS) message queues to process incoming asynchronous SIF requests. A message-driven bean listens on the queue for these requests, allowing the Hub Server to process them without requiring the client to wait for a synchronous response.
An MDM administrator is tasked with promoting a new, validated data model from the development environment to the production environment.
Which tool within the Hub Console is specifically designed for this purpose?