SnowPro Core Certification — Question 1192

A stream object will advance its offset when it is used in which statement?

Answer options

• A. SELECT
• B. INSERT
• C. CREATE
• D. COPY INTO [location]

Correct answer: B

Explanation

The correct answer is B, as an INSERT statement modifies data in the table and therefore advances the stream's offset. The other options, such as SELECT, CREATE, and COPY INTO, do not alter the data in a way that would cause the stream's offset to change.