COF-C02 Question 184

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B1

  Why Option B is correct: Tasks are frequently used to process change data capture (CDC) pipelines fed by Snowflake Streams. When sizing a warehouse for a task, your main performance metric is the volume of data waiting to be processed. By checking the stream size (e.g., using SYSTEM$STREAM_HAS_DATA or checking row counts), you can dynamically gauge or establish the baseline warehouse size required to ingest that specific workload efficiently.

• Chose B1

  B. Querying (SELECT) the size of the stream content would help determine the warehouse size. ✅ Correct. If your task is processing large streams (big batch of changes), you need more compute → bigger warehouse. If stream is small, XS/S is fine. 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. ✅ Correct. Since stored procs can have multiple steps (DML, transformations), you should benchmark them manually to pick the right warehouse size.

• 1

  B For queries in large-scale production environments, larger warehouse sizes (Large, X-Large, 2X-Large, etc.) may be more cost effective. https://docs.snowflake.com/en/user-guide/warehouses-considerations