Snowflake
COF-R02 · Question #70
How would you determine the size of the virtual warehouse used for a task?
The correct answer is C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored. See the full explanation below for the reasoning.
Question
How would you determine the size of the virtual warehouse used for a task?
Options
- ARoot task may be executed concurrently (i.e. multiple instances), it is recommended to leave some
- BQuerying (select) the size of the stream content would help determine the warehouse size. For
- CIf using the stored procedure to execute multiple SQL statements, it's best to test run the stored
- DSince task infrastructure is based on running the task body on schedule, it's recommended to
How the community answered
(45 responses)- A13% (6)
- B4% (2)
- C73% (33)
- D9% (4)
Community Discussion
No community discussion yet for this question.