
Answer-first summary for fast verification
Answer: SECURITYADMIN, USERADMIN
The question asks for the two roles recommended for creating and managing users and roles in Snowflake. According to Snowflake documentation and the community discussion consensus (with BE receiving 69% of votes and multiple upvoted comments confirming this), the correct roles are SECURITYADMIN (B) and USERADMIN (E). SECURITYADMIN inherits privileges from USERADMIN and can manage any object grant globally, create users/roles, and manage them. USERADMIN is specifically dedicated to user and role management with CREATE USER and CREATE ROLE privileges. Other options are less suitable: SYSADMIN (A) focuses on database objects, PUBLIC (C) is a default role with minimal privileges, and ACCOUNTADMIN (D) is a high-privilege role but not specifically recommended for routine user/role management.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.