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

Operational Reference Store (ORS)

Answer

Landing schema

Answer

Staging schema

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

The most restrictive privilege always wins

Answer

MDM throws an access denied error

Answer

The system uses the last applied role

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

Package privileges

Answer

Audit log access

Answer

Trust framework settings

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

ORS-level data filters

Answer

Hierarchy Manager subject areas

Answer

Secure view definitions

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 role can run data quality cleansing on records

Answer

The role can modify the cleanse function definition

Answer

The role gains access to all records processed by that function

Question 6

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

Accepted Answer

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

Answer

Assigning service accounts to the Admin role

Answer

Using shared user credentials for all ETL jobs

Answer

Granting MERGE privilege to enable all data operations

Question 7

When Informatica MDM is deployed in a multi-tenant environment, what isolates the security configurations of each tenant?

Accepted Answer

Separate ORS databases with distinct role configurations

Answer

Separate Hub Servers per tenant

Answer

VLAN-level network separation

Answer

Different Process Server instances