SnowPro Core Certification — Question 191

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Answer options

• A. UPDATE TABLE FROM STREAM
• B. SELECT FROM STREAM
• C. INSERT INTO TABLE SELECT FROM STREAM
• D. ALTER TABLE AS SELECT FROM STREAM
• E. BEGIN COMMIT

Correct answer: A, C

Explanation

The commands 'UPDATE TABLE FROM STREAM' and 'INSERT INTO TABLE SELECT FROM STREAM' are designed to modify data based on the stream's content, which causes the stream offset to advance. In contrast, 'SELECT FROM STREAM' simply reads data without altering it, and 'ALTER TABLE AS SELECT FROM STREAM' does not consume the stream. 'BEGIN COMMIT' is related to transaction control and does not interact with streams.