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

What are characteristics of the use of transactions in Snowflake? (Select TWO).
A) Explicit transactions can contain DDL, DML, and query statements. and C) A transaction can be started explicitly by executing a begin work statement and end explicitly by executing a commit work statement.
B) The autocommit setting can be changed inside a stored procedure.
D) A transaction can be started explicitly by executing a begin transaction statement and end explicitly by executing an end transaction statement.
E) Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.

Snowflake ARA-R01 Exam - Topic 4 Question 52 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 52
Topic #: 4
[All ARA-R01 Questions]

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

Show Suggested Answer Hide Answer
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.


Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel