MDM Security and Access Control 3

Question 1

In Informatica MDM, which database schema stores the security metadata including user roles and privileges?

Accepted Answer

CMX_SYSTEM schema

Answer

The CMX_SYSTEM schema is the MDM Hub's administrative database that stores system-level metadata including security configuration like roles and privileges.

Question 2

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

Accepted Answer

The least restrictive privilege always wins

Answer

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

Question 3

Which Informatica MDM security feature controls whether a user can see the change history (cross-reference records) of a master object?

Accepted Answer

Cross-reference read privilege

Answer

The cross-reference read privilege specifically controls a user's ability to view the source system contributions and history of a master record.

Question 4

An Informatica MDM implementation uses Hierarchy Manager. Which additional security element must be configured to restrict access to specific hierarchy nodes?

Accepted Answer

HM relationship base object privileges

Answer

Hierarchy Manager relationship base object privileges control which hierarchy relationships and nodes a user can view or modify within the Hierarchy Manager.

Question 5

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

Accepted Answer

The role can invoke the cleanse function via API calls

Answer

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

(MDM) Informatica Master Data Management Certification Practice Test

(MDM) Informatica Master Data Management Certification Practice Test

MDM Security and Access Control 3