Explanation:
The question asks for two valid commands when using secondary roles in Snowflake. According to the Snowflake documentation and the community discussion (with 100% consensus on CE), the valid syntax for the USE SECONDARY ROLES command includes 'ALL' and 'NONE'. 'USE SECONDARY ROLES ALL' enables all secondary roles granted to the user, while 'USE SECONDARY ROLES NONE' disables all secondary roles. Options A ('RESUME'), B ('SUSPEND'), and D ('ADD [Role Name]') are not valid syntax for this command, as confirmed by the referenced documentation links and community verification.
No comments yet.
Which statements are true regarding valid commands when using secondary roles? (Select two.)
A
USE SECONDARY ROLES RESUME
B
USE SECONDARY ROLES SUSPEND
C
USE SECONDARY ROLES ALL
D
USE SECONDARY ROLES ADD [Role Name]
E
USE SECONDARY ROLES NONE