How can this requirement be met?

An Administrator wants to delegate the administration of a company’s data exchange to users who do not have access to the ACCOUNTADMIN role.

How can this requirement be met?
A . Grant imported privileges on data exchange EXCHANGE_NAME to ROLE_NAME;
B . Grant modify on data exchange EXCHANGE_NAME to ROLE_NAME;
C . Grant ownership on data exchange EXCHANGE_NAME to ROLE NAME;
D . Grant usage on data exchange EXCHANGE_NAME to ROLE_NAME;

View Answer

Answer: D

Explanation:

In Snowflake, if an administrator wants to delegate the administration of the company’s data exchange to users who do not have the ACCOUNTADMIN role, they can grant those users USAGE permission on the data exchange. This allows the specified role to view the data exchange and request data without granting them the ability to modify or own it. This meets the requirement to delegate administration while maintaining appropriate separation of privileges.

Options A (Grant imported privileges on data exchange) and C (Grant ownership on data exchange) provide more permissions than necessary and may not be appropriate just for managing the data exchange. Option B (Grant modify on data exchange) might also provide unnecessary additional permissions, depending on what administrative tasks need to be performed. Typically, granting USAGE permission is the minimum necessary to meet basic administrative requirements.