SnowPro Advanced: Data Engineer — Question 34

Within a Snowflake account. permissions have been defined with custom roles and role hierarchies.
To set up column-level masking using a role in the hierarchy of the current user, what command would be used?

Answer options

• A. CURRENT_ROLE
• B. INVOKER_ROLE
• C. IS_ROLE_IN_SESSION
• D. IS_GRANTED_TO_INVOKER_ROLE

Correct answer: D

Explanation

The correct answer is D, as IS_GRANTED_TO_INVOKER_ROLE checks if the invoker's role has the necessary permissions for column-level masking. The other options do not provide the functionality required to confirm role permissions in this context.