Snowflake
COF-R02 · Question #211
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
The correct answer is C. INSERT INTO TABLE SELECT FROM STREAM D. ALTER TABLE AS SELECT FROM STREAM. See the full explanation below for the reasoning.
Question
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Options
- AUPDATE TABLE FROM STREAM
- BSELECT FROM STREAM
- CINSERT INTO TABLE SELECT FROM STREAM
- DALTER TABLE AS SELECT FROM STREAM
- EBEGIN COMMIT
How the community answered
(30 responses)- A7% (2)
- B17% (5)
- C73% (22)
- E3% (1)
Community Discussion
No community discussion yet for this question.