Which statements reflect valid commands when using secondary roles? (Choose two.)
Which statements reflect valid commands when using secondary roles? (Choose two.)
The valid commands when using secondary roles are 'USE SECONDARY ROLES ALL' and 'USE SECONDARY ROLES NONE'. These commands are used to specify the use of all assigned secondary roles or none, respectively, which are fundamental options in controlling role-based access within Snowflake.
https://thinketl.com/overview-of-snowflake-role-based-access-control/#The_Primary_and_Secondary_Roles https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
I think it should be C and E. "USE SECONDARY ROLES { ALL | NONE }" Reference from => https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles#syntax
https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
https://docs.snowflake.com/en/sql-reference/sql/use-secondary-roles.html
Verified
https://docs.snowflake.com/en/user-guide/security-access-control-overview