View all questions & answers for the SnowPro-Core exam
Which statements reflect valid commands when using secondary roles? (Select TWO).
Use SECONDARY ROLES RESUME
USE SECONDARY ROLES SUSPEND
USE SECONDARY RLES ALL
USE SECONDARY ROLES ADD
Use SECONDARY ROLES NONE
USE SECONDARY ROLES ALL: Activates all granted secondary roles for the current session.
USE SECONDARY ROLES NONE: Deactivates all active secondary roles for the current session.
Incorrect Commands: The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
Snowflake Documentation (USE SECONDARY ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
Submit