SnowPro Advanced: Data Engineer — Question 40

At what isolation level are Snowflake streams?

Answer options

• A. Snapshot
• B. Repeatable read
• C. Read committed
• D. Read uncommitted

Correct answer: B

Explanation

The correct answer is B, Repeatable read, as Snowflake streams maintain this level of isolation to ensure that data remains consistent during concurrent transactions. The other options, such as Snapshot, Read committed, and Read uncommitted, do not align with the behavior of Snowflake streams regarding data visibility and consistency.