COF-C02 Question #655: Real Exam Question with Answer & Explanation

The correct answer is D: Since task infrastructure is based on running the task body on schedule, it's recommended to. The size of the virtual warehouse for a task can be configured to handle concurrency automatically using a Multi-cluster warehouse (MCW). This is because tasks are designed to run their body on a schedule, and MCW allows for scaling compute resources to match the task's execution

Performance Management

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

Explanation

The size of the virtual warehouse for a task can be configured to handle concurrency automatically using a Multi-cluster warehouse (MCW). This is because tasks are designed to run their body on a schedule, and MCW allows for scaling compute resources to match the task's execution needs without manual intervention.

Topics

#Virtual Warehouses#Snowflake Tasks#Performance Tuning#Warehouse Sizing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions