Free Preparation Discussions
MENU
Snowflake Exam ADA-C01 Topic 2 Question 24 Discussion
Topic #: 2
What is a characteristic of Snowflake's transaction locking and concurrency modeling?
According to the Snowflake documentation1, 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. Option B is incorrect because queries and DML statements do not block each other in Snowflake, unless they are explicitly started transactions and multiple statements in each transaction2. Option C is incorrect because transaction locking in Snowflake is enforced at the partition level, not the row or table level3. Option D is incorrect because queries executed within a given transaction do not see that transaction's uncommitted changes, but only the committed changes that occurred before the transaction started1.
Jennie
2 months agoKimberlie
1 months agoElinore
1 months agoCarline
1 months agoChauncey
2 months agoMatt
2 months agoDelbert
1 months agoLynelle
1 months agoTimothy
2 months agoAlita
2 months agoAndree
2 months agoChauncey
2 months agoAmber
3 months agoLisha
1 months agoKasandra
2 months agoRonald
2 months agoStephaine
2 months agoEmilio
3 months agoOren
2 months agoHermila
2 months ago