Answer: Auto-suspend, Resource monitor

The question asks for two optional properties that can be set when creating a virtual warehouse in Snowflake. According to the Snowflake documentation referenced in the community discussion (specifically the CREATE WAREHOUSE command), the optional properties include AUTO_SUSPEND and RESOURCE_MONITOR. AUTO_SUSPEND allows automatic suspension of the warehouse after a specified period of inactivity, while RESOURCE_MONITOR enables setting a resource monitor to control credit usage. Other options are incorrect: B (Cache size) is not a configurable warehouse property, C (Default role) is a user/session property, and E (Storage size) is managed by Snowflake and not user-configurable for warehouses. The community discussion shows 100% consensus on AD with supporting documentation links.

Author: LeetQuiz Editorial Team