SnowPro Core Certification — Question 184

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Answer options

Correct answer: C

Explanation

The total billable compute time is 14 minutes. The warehouse auto-resumes for the first query that takes 3 minutes, and then it remains active for 10 additional minutes before auto-suspending after the user returns and runs a 10-second query. The other options are incorrect as they do not account for the full duration the warehouse was active.