Answer: Auto-resume when a query is in a queue., Auto-suspend after a specified period of inactivity.

The question asks for two ways to automate virtual warehouse operations for optimal credit consumption. Option A (Auto-resume when a query is in a queue) ensures the warehouse starts only when needed, avoiding idle running costs. Option E (Auto-suspend after a specified period of inactivity) stops the warehouse during idle periods, preventing unnecessary credit usage. These two settings work together to optimize costs by running the warehouse only during active workloads. Options B, C, and D are incorrect: B (auto-resume after a set time period) would start the warehouse unnecessarily without a query, wasting credits; C (auto-suspend while the query is being written) is not a valid Snowflake feature and would interrupt active queries; D (auto-suspend after a set time period) is less precise than inactivity-based suspension and could stop the warehouse during active use. The community discussion confirms AE as the correct answer with 100% consensus, emphasizing that these settings optimize credit consumption by aligning warehouse operation with actual workload demands.

Author: LeetQuiz Editorial Team