Exam SnowPro Advanced Architect topic 1 question 79 discussion

"A. Explicit transactions should contain only DML statements and query statements. DDL statements implicitly commit active transactions B. Caution: Do not change AUTOCOMMIT settings inside a stored procedure. You will get an error message. C. A transaction can be started explicitly by executing a BEGIN statement. Snowflake supports the synonyms BEGIN WORK and BEGIN TRANSACTION. Snowflake recommends using BEGIN TRANSACTION. A transaction can be ended explicitly by executing COMMIT or ROLLBACK. Snowflake supports the synonym COMMIT WORK for COMMIT, and the synonym ROLLBACK WORK for ROLLBACK. D. BEGIN TRANSACTION can be used to start a transaction, but there is no END TRANSACTION statement. To end, COMMIT or ROLLBACK is used. E. (Same note as A) Explicit transactions should contain only DML statements and query statements. DDL statements implicitly commit active transactions https://docs.snowflake.com/en/sql-reference/transactions#what-is-a-transaction"

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

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