SnowPro Core Streams and Tasks

Question 1

What is a Snowflake Stream primarily used for?

Accepted Answer

Tracking DML changes (INSERT, UPDATE, DELETE) on a table for CDC workflows

Answer

Storing large files in cloud object storage

Answer

Scheduling periodic SQL queries on a defined interval

Answer

Compressing and archiving historical data for cost savings

Question 2

Which metadata columns are automatically included when querying a Snowflake Stream?

Accepted Answer

METADATA$ACTION, METADATA$ISUPDATE, METADATA$ROW_ID

Answer

STREAM_ID, STREAM_TIME, STREAM_ACTION

Answer

CHANGE_TYPE, CHANGE_TIME, ROW_HASH

Answer

CDC_ACTION, CDC_TIMESTAMP, CDC_KEY

Question 3

What happens to records in a Snowflake Stream after they are successfully consumed in a DML transaction?

Accepted Answer

The stream offset advances and those records are no longer visible in the stream

Answer

They are moved to a backup retention table for 90 days

Answer

They are replicated to all secondary accounts automatically

Answer

They are deleted from the source table immediately

Question 4

When does a Snowflake Stream become stale and unusable?

Accepted Answer

When its offset falls outside the source table's DATA_RETENTION_TIME_IN_DAYS window

Answer

After exactly 7 days regardless of account edition or table settings

Answer

When the stream has not been queried for more than 24 hours

Answer

After the stream accumulates more than 1 million change records

Question 5

Which of the following Snowflake object types can have a stream created on it?

Accepted Answer

Tables, external tables, views (with limitations), and directory tables

Answer

Only standard (permanent) tables

Answer

Tables and materialized views only

Answer

Stages and pipes only

Question 6

In a Snowflake Stream, what does a row with METADATA$ACTION = 'DELETE' and METADATA$ISUPDATE = TRUE represent?

Accepted Answer

The pre-image (old values) of a row that was updated

Answer

A row that was permanently deleted using a DELETE statement

Answer

A DELETE statement that was rolled back in a transaction

Answer

A stream reset operation performed by the account administrator

Question 7

Which stream type in Snowflake captures ALL DML changes including inserts, updates, and deletes?

Accepted Answer

Standard (delta) stream

Answer

Append-only stream

Answer

Insert-only stream

Answer

External stream