If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
Correct Answer: A
Question 509
By default, which role can create resource monitors?
Correct Answer: A
The role that can by default create resource monitors in Snowflake is the ACCOUNTADMIN role. Resource monitors are a crucial feature in Snowflake that allows administrators to track and control the consumption of compute resources, ensuring that usage stays within specified limits. The creation and management of resource monitors involve defining thresholds for credits usage, setting up notifications, and specifying actions to be taken when certain thresholds are exceeded. Given the significant impact that resource monitors can have on the operational aspects and billing of a Snowflake account, the capability to create and manage them is restricted to the ACCOUNTADMIN role. This role has the broadest set of privileges in Snowflake, including the ability to manage all aspects of the account, such as users, roles, warehouses, databases, and resource monitors, among others. References: * Snowflake Documentation on Resource Monitors: Managing Resource Monitors
Question 510
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
