exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 242 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 242
Topic #: 1
[All SnowPro Core Questions]

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?

  • A. 4 minutes
  • B. 10 minutes
  • C. 14 minutes
  • D. 24 minutes
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
stornati
Highly Voted 1 year, 10 months ago
Selected Answer: C
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
upvoted 16 times
v1tjkee
1 year ago
Why after the second run WH suspends after 1 min if autosuspend set to 10 min?
upvoted 1 times
Rajivnb
11 months, 3 weeks ago
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.
upvoted 2 times
...
...
...
PrasantSadangi
Most Recent 4 days, 20 hours ago
Selected Answer: C
14 Mins
upvoted 1 times
...
deeshubh
5 months ago
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
upvoted 2 times
...
_yyukta
7 months, 1 week ago
Selected Answer: C
C. 14 minutes
upvoted 1 times
...
SCube
11 months ago
If the warehouse is currently suspended , how does the 3 min query get executed, if someone can answer plz
upvoted 1 times
sandalz
8 months, 1 week ago
bc auto resume is on
upvoted 2 times
...
...
jAtlas7
1 year ago
Selected Answer: C
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.
upvoted 2 times
...
stornati
1 year, 1 month ago
Selected Answer: D
3 +10 (idle before auto suspend) +1 (run quey) + 10 (idle before auto suspend, since user gone without suspend)
upvoted 3 times
...
v1tjkee
1 year, 3 months ago
Selected Answer: D
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?
upvoted 1 times
samudu141
1 year, 2 months ago
BECAUSE MANULLY SUSPEND
upvoted 2 times
...
...
Faouzi5
1 year, 3 months ago
The correct answer is 24: 3 +10 (idle before auto suspend) +1 + 10 (idle before auto suspend)
upvoted 2 times
SCube
11 months ago
Cannot be 24 because the user suspends the warehouse after the last query is complete.
upvoted 1 times
...
...
RajuNaik
1 year, 5 months ago
Selected Answer: C
14 min
upvoted 1 times
...
fahfouhi94
1 year, 8 months ago
Selected Answer: C
3 min of the first query running + 10 min berfore the auto-suspend + 1 min (min for a new exection)
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago