SnowPro Advanced: Administrator — Question 3

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

Answer options

• A. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
• B. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
• C. Transaction locking in Snowflake is enforced exclusively at the row and table levels.
• D. Queries executed within a given transaction see that transaction's uncommitted changes.

Correct answer: A

Explanation

The correct answer is A because Snowflake's architecture is designed to prevent deadlocks by allowing concurrent queries and DML operations to execute without blocking each other. Answer B is incorrect as it suggests blocking behavior that does not occur in Snowflake. Answers C and D are also incorrect as they misrepresent how Snowflake manages transaction locking and visibility of changes.