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 are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

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:

Lindsey
6 hours ago
But the account name must be unique within the organization, so it has to be E.
upvoted 0 times
...
Juan
8 hours ago
Hmm, the account name being immutable is interesting. I wonder if that's to prevent any accidental changes down the line.
upvoted 0 times
...
Krystina
1 days ago
I disagree, I believe it's A and D.
upvoted 0 times
...
Tamar
3 days ago
I'm pretty sure the account name must be unique within the organization, but I'm not sure about the other requirements. This exam is really testing our Snowflake knowledge!
upvoted 0 times
...
Lindsey
4 days ago
I think the requirements are C and E.
upvoted 0 times
...

Save Cancel