In Snowflake, is a transaction inside a stored procedure treated as autonomous and not nested within the outer transaction?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

In Snowflake, is a transaction inside a stored procedure treated as autonomous and not nested within the outer transaction?

Explanation:
Transactions inside a Snowflake stored procedure have their own boundary. The code in the procedure can begin, commit, or roll back a transaction independently of the outer transaction, so the inner work is isolated from the caller’s transaction. This autonomy means the inner transaction is not simply nested under the outer one, which is why the correct choice portrays the inner transaction as autonomous.

Transactions inside a Snowflake stored procedure have their own boundary. The code in the procedure can begin, commit, or roll back a transaction independently of the outer transaction, so the inner work is isolated from the caller’s transaction. This autonomy means the inner transaction is not simply nested under the outer one, which is why the correct choice portrays the inner transaction as autonomous.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy