QuestionQ23Verified/Perform database monitoring, tuning, and optimizationCopy linkReport a problemAsk AstroTutorSave questionWhat is one characteristic of Snowflake’s transaction locking and concurrency model?AA deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.BIf two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.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.Show AnswerAnswerExplanationWithin a multi-statement transaction, Snowflake makes changes from earlier statements in that same transaction visible to subsequent statements even before those changes are committed. Other transactions do not see uncommitted data under READ COMMITTED isolation.Learn moreTransactions | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion