What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).

The correct answer is A. Auto-suspend D. Resource monitor. When creating a virtual warehouse with CREATE WAREHOUSE, optional configurable properties include: AUTO_SUSPEND (A) - sets idle time in seconds before the warehouse suspends automatically; RESOURCE_MONITOR (D) - assigns a resource monitor to track and limit credit usage. Cache…

Performance Management

Question

Options

AAuto-suspend
BCache size
CDefault role
DResource monitor
EStorage size

How the community answered

(44 responses)

C
5% (2)
D
93% (41)
E
2% (1)

Explanation

When creating a virtual warehouse with CREATE WAREHOUSE, optional configurable properties include: AUTO_SUSPEND (A) - sets idle time in seconds before the warehouse suspends automatically; RESOURCE_MONITOR (D) - assigns a resource monitor to track and limit credit usage. Cache size (B) is managed automatically by Snowflake and cannot be configured by users. Default role (C) is a user-level property, not a warehouse property. Storage size (E) is irrelevant to virtual warehouses, which are compute resources, not storage - Snowflake separates compute from storage.

Topics

#Virtual Warehouse#Warehouse Configuration#Resource Monitoring#Auto-suspend

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice