snowpro-advanced-architect question 42 discussion

View all snowpro advanced architect here
back to snowflake forum

Question 42

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend 60 and used exclusively for this task, which statement is true?

  • A. The warehouse MY_WH will be made active every five minutes to check the stream.
  • B. The warehouse MY_WH will only be active when there are results in the stream.
  • C. The warehouse MY_WH will never suspend.
  • D. The warehouse MY_WH will automatically resize to accommodate the size of the stream.
Answer:

a

User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D
50%
Discussions
0 / 1000
anireddy
7 months ago

option A good

0