QuestionQ75Verified/Data Storage and ProcessingCopy linkReport a problemAsk AstroTutorSave questionWhich statements describe the use of transactions in Snowflake?Choose twoAExplicit 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 executing a COMMIT WORK statement.DA transaction can be started explicitly by executing a BEGIN TRANSACTION statement and end explicitly by executing an END TRANSACTION statement.EExplicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.Show AnswerAnswerExplanationSnowflake supports BEGIN WORK and BEGIN TRANSACTION as explicit transaction-start statements, and supports COMMIT WORK as a synonym for COMMIT. Explicit transactions should contain only DML and query statements because every DDL statement implicitly commits any active transaction and executes separately.Learn moreTransactions | Snowflake DocumentationShow comments2Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion