How would you determine the size of the virtual warehouse used for a task?

Question

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

• A
  7% (1)
• B
  14% (2)
• D
  79% (11)

Explanation

The correct approach to sizing a warehouse for a Snowflake Task is to test-run the task body (the SQL or stored procedure) in isolation with different warehouse sizes and measure execution time and credit consumption. Since Snowflake Tasks execute on a schedule without interactive feedback, you should benchmark the workload before committing to a warehouse size. The other options (A, B, C) are partial or misleading concepts - querying stream content size or noting concurrency concerns are secondary considerations, but the foundational sizing method is empirical test execution of the task's workload.

No community discussion yet for this question.