COF-C02 · Question #151
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…
The correct answer is C. 14 minutes. The billable compute time includes the time the warehouse is running queries plus the auto- suspend time after the last query if the warehouse is not manually suspended. In this scenario, the warehouse runs for 3 minutes, suspends after 10 minutes of inactivity, resumes for a…
Question
Options
- A4 minutes
- B10 minutes
- C14 minutes
- D24 minutes
How the community answered
(28 responses)- A7% (2)
- B14% (4)
- C71% (20)
- D7% (2)
Explanation
The billable compute time includes the time the warehouse is running queries plus the auto- suspend time after the last query if the warehouse is not manually suspended. In this scenario, the warehouse runs for 3 minutes, suspends after 10 minutes of inactivity, resumes for a 10- second query, and then is manually suspended. The total billable time is the sum of the initial 3 minutes, the 10 minutes of auto-suspend time, and the brief period for the 10-second query, which is rounded up to the next full minute due to Snowflake's billing practices.
Topics
Community Discussion
No community discussion yet for this question.