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
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 1 year, 1 month agojjordan
Most Recent 6 months, 3 weeks agoGLEM
11 months, 1 week agohillcat111
11 months, 2 weeks agovictorleonis
1 year agotaod
1 year, 1 month ago