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 ARA-R01 Exam - Topic 4 Question 52 Discussion

Posted by Elouise on Sep 30, 2026 at 09:55 PM

What are characteristics of the use of transactions in Snowflake? (Select TWO).

Suggested Answer: A, C

A. Snowflake's transactions can indeed include DDL (Data Definition Language), DML (Data Manipulation Language), and query statements. When executed within a transaction block, they all contribute to the atomicity of the transaction---either all of them commit together or none at all. C. Snowflake supports explicit transaction control through the use of the BEGIN TRANSACTION (or simply BEGIN) and COMMIT statements. Alternatively, the BEGIN WORK and COMMIT WORK syntax is also supported, which is a standard SQL syntax for initiating and ending transactions, respectively. Note: The END TRANSACTION statement is not used in Snowflake to end a transaction; the correct statement is COMMIT or COMMIT WORK.


Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
9 comments · newest first
MA
Malcolm 4 days ago
Wait, all DDL statements commit? That seems off!
KA
Karina 9 days ago
B is interesting, didn't know you could change autocommit in a stored procedure.
VA
Van 14 days ago
Totally agree with A!
LO
Lonna 19 days ago
I thought DDL could be in transactions too?
ER
Eric 25 days ago
A) and D) are correct!
KR
Krystal 30 days ago
I feel like I read that explicit transactions shouldn't mix DDL with DML, which might support option E, but I'm not completely confident about that.
EL
Elvis 1 month ago
I practiced a question similar to this, and I recall that transactions start with "begin transaction," so option D sounds right to me.
KA
Katy 1 month ago
I'm not entirely sure, but I think the autocommit setting can be changed in a stored procedure, which makes me lean towards option B.
AD
Adrianna 2 months ago
I remember that explicit transactions can include DDL and DML, so I think option A might be correct.
0/2000 characters

Save Cancel