Snowflake SnowPro Certification Practice Test

To change the configuration of a Virtual Warehouse, which administrative role is typically required?

1. User

2. Public Role

3. Account Administrator

4. Read-Only Role

The correct answer is: Account Administrator

To change the configuration of a Virtual Warehouse in Snowflake, an Account Administrator role is typically required because this role is designed for users who need full control over the account's configurations and settings, including managing Virtual Warehouses. The Account Administrator role contains privileges to create, modify, and drop warehouses, as well as set resource monitors and manage scaling configurations, which are essential for optimizing performance and cost management in Snowflake. Roles such as User and Read-Only Role have limited permissions. Users can interact with the data and run queries, while the Read-Only Role is primarily for access to view data without making any changes. The Public Role is intended for default access granted to all users and does not provide the necessary permissions to alter warehouse configurations. Therefore, only an Account Administrator has the requisite permissions to manage and configure Virtual Warehouses effectively.