Answer: 14 minutes

The correct answer is 14 minutes. Here's the breakdown: (1) First query execution: 3 minutes (warehouse starts and runs the query). (2) After the first query, the warehouse remains active and starts the 10-minute auto-suspend countdown. Since the user leaves for 15 minutes, the warehouse idles for 10 minutes before auto-suspending (this 10 minutes is billable as the warehouse remains active). (3) When the user returns and runs the second query (10 seconds), the warehouse auto-resumes (due to auto-resume being enabled) and runs the query. Snowflake bills compute time in 1-minute increments, so the 10-second query is billed as 1 minute. (4) The user manually suspends the warehouse immediately after the second query, so no additional idle time is billed. Total: 3 (first query) + 10 (idle time until auto-suspend) + 1 (second query) = 14 minutes. Option D (24 minutes) is incorrect because the user manually suspends the warehouse after the second query, preventing another 10-minute idle period. Options A (4 minutes) and B (10 minutes) underestimate the billable time by ignoring the idle time or query execution increments.

Author: LeetQuiz Editorial Team