Snowflake Data Engineer Practice Exam

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
Session length

1 / 20

Why can the association between a stage and its storage integration break when you recreate the storage integration?

Because the stage name changed during CREATE OR REPLACE

Because the stage links to a storage integration by a hidden ID, which changes when the integration is recreated

The link between a stage and a storage integration is established via an internal identifier tied to the storage integration object. When you recreate the storage integration with CREATE OR REPLACE, Snowflake effectively creates a new integration object with a new internal ID. The stage’s existing binding points to the old internal ID, so after recreation the association breaks because the stage no longer references the updated integration. Rebinding the stage to the (new) integration name (for example, with ALTER STAGE ... STORAGE_INTEGRATION = 'your_integration') resolves the issue.

Because Snowflake caches the mapping and requires a refresh

Because the data itself is moved

Next Question
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy