
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.
Ultimate access to all questions.
No comments yet.