Module Assessment

1.

A user has two security roles assigned. Role A grants Read at the User level on the Transactions table. Role B grants Read at the Business Unit level on the same table. What is the user's effective Read access?

Business Unit level - privileges accumulate to the highest level granted.

User level - the more restrictive role takes precedence.

The roles conflict and access is denied until one is removed.

2.

You need to restrict access to a CreditLimit column so that most users see masked values but compliance officers see full values. Which approach should you use?

Create two column security profiles - one with Read Unmasked set to All Records for compliance, and one with Read Unmasked set to Not Allowed for other users.

Create two security roles with different Read access levels on the table.

Put compliance officers in a different business unit so they see different column data.

3.

You create a Microsoft Entra group team in Dataverse and assign it the 'Transaction Analyst' security role. When do team members receive the role's privileges?

When they first access the environment - members are provisioned just-in-time.

Immediately when they're added to the Entra ID group.

After an administrator manually syncs the team membership.

4.

A store manager needs Read access to transaction records in both the Stores and Zava Pay business units without being moved to a different unit. What's the recommended approach?

Enable matrix data access and assign security roles from both business units, or use an access team for cross-unit sharing.

Assign the System Administrator role, which bypasses business unit restrictions.

Create a duplicate record in the Stores business unit for each Zava Pay record they need.

5.

Which column types can't have column-level security enabled?

Lookup columns, formula columns, primary name columns, and system columns (createdon, modifiedon)

Currency columns, date columns, and choice columns

Any column in a custom table - only standard table columns support security

Check your knowledge

Feedback