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.
Not true, B would be correct. Warehouse is only started if condition is met:
https://docs.snowflake.com/en/sql-reference/sql/create-task
https://docs.snowflake.com/en/sql-reference/functions/system_stream_has_data
upvoted 3 times
...
Log in to ExamTopics
Sign in:
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.
Jay_98_11
Highly Voted 7 months, 4 weeks agojjordan
Most Recent 4 weeks agoGLEM
5 months, 1 week agohillcat111
5 months, 2 weeks agovictorleonis
6 months, 4 weeks agotaod
8 months ago