ADA-C01 · Question #20
What is a characteristic of Snowflake's transaction locking and concurrency modeling?
The correct answer is A. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements. Snowflake uses a multi-version concurrency control (MVCC) model, which means that each transaction operates on a consistent snapshot of the database at a point in time. This allows queries and DML statements to run concurrently without blocking each other, as they do not modify…
Question
What is a characteristic of Snowflake's transaction locking and concurrency modeling?
Options
- AA deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements
- BIf two queries are concurrently executed against the same table, one of the two queries will be
- CTransaction locking in Snowflake is enforced exclusively at the row and table levels.
- DQueries executed within a given transaction see that transaction's uncommitted changes.
How the community answered
(28 responses)- A82% (23)
- B11% (3)
- C4% (1)
- D4% (1)
Explanation
Snowflake uses a multi-version concurrency control (MVCC) model, which means that each transaction operates on a consistent snapshot of the database at a point in time. This allows queries and DML statements to run concurrently without blocking each other, as they do not modify the same data. Therefore, a deadlock, which occurs when concurrent transactions are waiting on resources that are locked by each other, cannot happen in Snowflake.
Topics
Community Discussion
No community discussion yet for this question.