SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ91

VerifiedData Storage and Processing

An Architect is establishing transaction rules that comply with ACID (Atomicity, Consistency, Isolation, Durability) properties for a project, ensuring executed statements are either committed or rolled back.

Based on this scenario, which transaction characteristics should be considered?

Choose two
Explanation

Explicit transactions should contain only DML and query statements because every DDL statement implicitly commits an active transaction and executes independently. An explicit transaction can be initiated with BEGIN WORK and completed with COMMIT WORK, which are supported synonyms for BEGIN and COMMIT.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!