SnowPro Advanced: Architect — Question 81

What are characteristics of the use of transactions in Snowflake? (Choose two.)

Answer options

• A. Explicit transactions can contain DDL, DML, and query statements.
• B. The AUTOCOMMIT setting can be changed inside a stored procedure.
• C. A transaction can be started explicitly by executing a BEGIN WORK statement and end explicitly by executing a COMMIT WORK statement.
• 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.

Correct answer: C, E

Explanation

The correct answer is C because it accurately describes how to start and end a transaction in Snowflake using the BEGIN WORK and COMMIT WORK commands. Option E is incorrect since explicit transactions can include DDL statements; stating they should only contain DML and queries is misleading. Other options either misrepresent transaction behavior or are not applicable in this context.