SnowPro Core Certification — Question 228

According to Snowflake best practice recommendations, which role should be used to create databases?

Answer options

• A. ACCOUNTADMIN
• B. SYSADMIN
• C. SECURITYADMIN
• D. USERADMIN

Correct answer: B

Explanation

The SYSADMIN role is designed for managing database objects and is the recommended role for creating databases in Snowflake. The ACCOUNTADMIN role has broader privileges, but for database creation specifically, SYSADMIN is the best practice. The SECURITYADMIN and USERADMIN roles do not have the necessary permissions to create databases.