Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 604

By default, which role has privileges to create tables and views in an account?

    Correct Answer: C

    The SYSADMIN role is a system-defined role that has privileges to create warehouses, databases, and other database objects such as tables and views in an account. By default, the SYSADMIN role is used for these administrative tasks. PUBLIC, SECURITYADMIN, and USERADMIN roles do not have these specific privileges by default.

Discussion
AleksanderSztrekerOption: C

The SYSADMIN role is a system-defined role that has privileges to create warehouses, databases, and database objects in an account and grant those privileges to other roles. https://docs.snowflake.com/en/user-guide/security-access-control-configure#creating-a-role-hierarchy

MultiCloudIronManOption: C

Correct