
Answer-first summary for fast verification
Answer: USE SECONDARY ROLES ALL, USE SECONDARY ROLES NONE
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.