COF-C03 Practice Question: Performance Optimization, Querying, and Transformation
A developer is building a Change Data Capture (CDC) pipeline using Snowflake. Which TWO features are required to ensure that only new or modified data is processed and that the processing logic runs automatically whenever data arrives?
⚠ Common exam trap
Candidates often confuse streams and tasks with stored procedures or third-party orchestrators like Airflow. They forget that Snowflake provides native continuous CDC processing components specifically through this pairing.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Streams
Modern data pipelines in Snowflake rely on the synergy between Streams and Tasks to achieve efficient CDC. Streams provide the ability to track changes at the row level without manual versioning, while Tasks provide the scheduling and execution framework. Together, they allow for automated, incremental processing that reduces latency and optimizes resource consumption.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Streams
Why this is correct
Streams provide a 'change table' that tracks DML changes made to a source table, including inserts, updates, and deletes. They record the current offset and allow consumers to read exactly what has changed since the last time the stream was consumed, making them the foundational component for incremental data loading.
- ✓
Tasks
Why this is correct
Tasks allow for the scheduled execution of SQL statements or stored procedures. When combined with a stream, a task can be configured to run only when the stream contains data, ensuring that compute resources are only used when there is actual work to perform in the data pipeline.
- ✗
External Tables
Why it's wrong here
External tables allow users to query data stored in cloud storage without loading it into Snowflake. While they are useful for initial ingestion or data lake architectures, they do not inherently provide the change tracking or automated scheduling logic required for a robust CDC pipeline within Snowflake.
- ✗
Stored Procedures
Why it's wrong here
Stored procedures can contain the logic for data transformation, but they do not provide the mechanism for tracking changes or the automated trigger for execution. While often used inside a task, they are not the primary feature responsible for identifying new or modified data records.
- ✗
Dynamic Tables
Why it's wrong here
Dynamic tables are a newer feature that simplifies data engineering by declaratively defining the end state of a table. While they use streams and tasks internally, the question asks for the specific underlying features used to build a pipeline, and standard Streams/Tasks offer more granular control for complex logic.
Visual reference
About these practice questions
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.