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

Question

Options

• AExplicit transactions can contain DDL, DML, and query statements.
• BThe autocommit setting can be changed inside a stored procedure.
• CA transaction can be started explicitly by executing a begin work statement and end explicitly by
• DA transaction can be started explicitly by executing a begin transaction statement and end
• EExplicit transactions should contain only DML statements and query statements. All DDL

• A
  88% (57)
• B
  2% (1)
• D
  5% (3)
• E
  6% (4)

Explanation

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. 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.

No community discussion yet for this question.