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?
The total billable compute time is 14 minutes. When the user runs the first query that takes 3 minutes, the warehouse auto-resumes and remains active, accounting for 3 minutes. The warehouse stays idle for 10 minutes before auto-suspending, leading to a total of 13 minutes so far. When the user returns and runs a second query that takes 10 seconds, the minimum billable time is 1 minute. Therefore, the total billable time is 13 minutes (from the first session) plus 1 minute (from the second session), making the total billable compute time 14 minutes.
I think it is 14 mins because: 3 Minutes for running first time (starting the WH and first execution) Leave for 15 minutes. WH will be iddle after 10 mins. ==> 10 + 3 New execuion = Minimal is 1 minute billed. so: 10+3+1 = 14
Why after the second run WH suspends after 1 min if autosuspend set to 10 min?
4th point in the question says the user suspended the Warehouse manually immediately after the second query is completed. if the user would have left the warehouse active then it would have been 24.
3 min of the first query running + 10 min berfore the auto-suspend + 1 min (min for a new exection)
3 +10 (idle before auto suspend) +1 (run quey) + 10 (idle before auto suspend, since user gone without suspend)
3 Minutes for running first time (starting the WH and first execution) Leave for 15 minutes. WH will be idle after 10 mins. ==> 10 + 3 New execution 10seconds = Minimal is 1 minute billed. total :- 14
First run: 3 minute query plus the default 10 minutes until the warehouse is suspended is 13 minutes. Second run: 10 second query (billed as 1 minute) and then immediate manual suspension is only still 1 minute. 13+1 = 14 minutes.
The correct answer is 24: 3 +10 (idle before auto suspend) +1 + 10 (idle before auto suspend)
Cannot be 24 because the user suspends the warehouse after the last query is complete.
C. 14 minutes
If the warehouse is currently suspended , how does the 3 min query get executed, if someone can answer plz
bc auto resume is on
I couldn't understand why after the first query (3min) we have 10 minutes before WH is suspended, then after the second query (10sec) we don't have 10 minutes before WH is suspended?
BECAUSE MANULLY SUSPEND
14 min