COF-C02 · Question #649
COF-C02 Question #649: Real Exam Question with Answer & Explanation
The correct answer is D: Resource monitor. When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor. Auto-suspend: This property defines the period of inactivity after wh
Question
What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
Options
- AAuto-suspend
- BCache size
- CDefault role
- DResource monitor
- EStorage size
Explanation
When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor. Auto-suspend: This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL' AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity Resource monitor: Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage. CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL' RESOURCE_MONITOR = 'my_resource_monitor';
Topics
Community Discussion
No community discussion yet for this question.