Answer: Auto-resume, Auto-suspend

The question asks for two configurable options when creating a Virtual Warehouse in Snowflake. Based on Snowflake documentation and the community discussion consensus (with multiple comments confirming CD and upvotes supporting this selection), the correct answers are C (Auto-resume) and D (Auto-suspend). Auto-resume allows the warehouse to automatically resume when a query is submitted after being suspended, and Auto-suspend specifies the idle time after which the warehouse automatically suspends to save costs. Option A (Auto-drop) is not a valid warehouse creation option, as dropping a warehouse is a manual administrative action. Option B (Auto-resize) is also not a configurable option at creation; scaling is managed through size selection or multi-cluster warehousing, not an 'auto-resize' setting. The community discussion shows strong agreement on CD, with detailed reasoning explaining that these are standard, configurable parameters in warehouse setup.

Author: LeetQuiz Editorial Team