SnowPro Core Certification — Question 899
Which command removes a role from another role or a user in Snowflake?
Answer options
- A. ALTER ROLE
- B. REVOKE ROLE
- C. USE ROLE
- D. USE SECONDARY ROLES
Correct answer: B
Explanation
The correct answer is B, REVOKE ROLE, as it specifically removes roles from users or other roles in Snowflake. A, ALTER ROLE, is used to modify role properties, while C, USE ROLE, changes the current role context, and D, USE SECONDARY ROLES, allows the use of secondary roles but does not remove any roles.