SnowPro Core Certification — Question 1158

How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Choose two.)

Answer options

• A. Auto-resume when a query is in a queue.
• B. Auto-resume after a set time period.
• C. Auto-suspend while the query is being written.
• D. Auto-suspend after a set time period.
• E. Auto-suspend after a specified period of inactivity.

Correct answer: A, E

Explanation

The correct answers, A and E, allow for efficient handling of resources by automatically resuming the warehouse when queries are queued and suspending it after a period of inactivity, thus optimizing credit usage. Options B and D do not effectively address credit consumption since they rely on set time periods rather than query activity, and option C is not valid as suspending while writing a query would interrupt the operation.