What should you assign?

HOTSPOT

A company uses two SQL Server environments and two Common Data Service environments.

The company policy states that only specific administrators can create environments. SQL Server and Common Data Service groups must be distinct.

You need to assign security access.

What should you assign? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Graphical user interface, text, application

Description automatically generated

Box 1: System Administrator and Environment Security group Security model for the databases When a database is created, the users who have environment roles assigned to them, will continue to maintain those privileges.

Users with Environment Admin role are now assigned to System Administrator role. Users with Environment Maker continue to possess the same role.

Box 2: Environment Admin

The Environment Admin role can perform all administrative actions on an environment, including the following:

✑ Add or remove a user from either the Environment Admin or Environment Maker role.

Box 3: Environment Maker

Environment Maker: Can create new resources associated with an environment, including apps, connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role doesn’t have any privileges to access data within an environment. More information:

Box 4: System Customizer

System Customizer: Has full permission to customize the environment. However, users with this role can only view records for environment entities that they create.