SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ61

VerifiedImplement Data Protection and Recovery

Within a Snowflake account, permissions have been defined using custom roles and role hierarchies.

To configure column-level masking by using a role in the current user's hierarchy, which command would be used?

Explanation

IS_ROLE_IN_SESSION verifies whether a specified account role is in the active primary or secondary role hierarchy of the current user’s session. Snowflake recommends this function in masking-policy conditions when role hierarchy and inherited privileges must be evaluated.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!