SnowPro Core Certification — Question 56

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

Answer options

• A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
• B. Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
• C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
• D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Correct answer: C

Explanation

The correct answer, C, emphasizes the importance of testing a stored procedure individually to accurately gauge the necessary compute resources before executing multiple SQL statements. Options A, B, and D do not directly address assessing the warehouse size in the context of stored procedures and are focused on different aspects of task execution and resource management.