SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 77

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

Explicit transactions can contain DDL, DML, and query statements.

The AUTOCOMMIT setting can be changed inside a stored procedure.

A transaction can be started explicitly by executing a BEGIN WORK statement and end explicitly by executing a COMMIT WORK statement.

A transaction can be started explicitly by executing a BEGIN TRANSACTION statement and end explicitly by executing an END TRANSACTION statement.

Explicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.

Correct Answer: C, E

In Snowflake, a transaction can be explicitly started by executing a BEGIN WORK statement and can be explicitly ended by executing a COMMIT WORK statement. Explicit transactions in Snowflake should contain only DML (Data Manipulation Language) statements and query statements. All DDL (Data Definition Language) statements implicitly commit active transactions, making it not recommended to mix DDL and DML statements in explicit transactions.

Discussion

swe12Options: CE

CE is right https://docs.snowflake.com/en/sql-reference/transactions