COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ88

Performance Optimization, Querying & Transformation

A table is updated during the day. A user wants to automate table-change processing by capturing only changed rows every 20 minutes and applying business transformations without manual intervention.

How should this be achieved?

Explanation

A Snowflake stream captures change data from the table, so transformations can process only rows that changed. A task scheduled every 20 minutes provides the required fixed cadence and executes those transformations automatically. Snowflake supports combining a scheduled task with stream-based change detection.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!