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