Exam SnowPro Advanced Architect topic 1 question 79 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 79
Topic #: 1

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

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.

Show Suggested Answer

Suggested Answer: CE 🗳️

by swe12 at March 7, 2024, 7:50 p.m.

Submit Cancel

3 months ago

Selected Answer: CE

validated https://docs.snowflake.com/en/sql-reference/transactions

upvoted 2 times

...

7 months, 2 weeks ago

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

upvoted 2 times

...