Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ADA-C01 Topic 2 Question 24 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 24
Topic #: 2
[All ADA-C01 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A

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.


Contribute your Thoughts:

Jennie
11 days ago
All these options sound like some kind of sorcery to me. I'll just go with whichever one has the most dragons in it.
upvoted 0 times
...
Chauncey
15 days ago
But A makes sense because Snowflake does not block queries.
upvoted 0 times
...
Matt
15 days ago
D looks good to me. Being able to see your own uncommitted changes is a must-have feature.
upvoted 0 times
Alita
8 days ago
User 1: D looks good to me. Being able to see your own uncommitted changes is a must-have feature.
upvoted 0 times
...
...
Andree
16 days ago
I disagree, I believe the answer is C.
upvoted 0 times
...
Chauncey
17 days ago
I think the answer is A.
upvoted 0 times
...
Amber
28 days ago
I'm going with C. Locking at the row and table levels is the way to go for a data warehouse like Snowflake.
upvoted 0 times
Ronald
10 days ago
I disagree, I believe D is the right choice. Queries within a transaction see uncommitted changes.
upvoted 0 times
...
Stephaine
21 days ago
I think A is the correct answer. Deadlocks cannot occur in Snowflake.
upvoted 0 times
...
...
Emilio
1 months ago
A seems legit. No deadlocks? Sounds like a dream come true for developers!
upvoted 0 times
Oren
19 days ago
User 2: That does sound like a dream come true for developers!
upvoted 0 times
...
Hermila
22 days ago
User 1: A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
upvoted 0 times
...
...

Save Cancel