Which statement is true about the handling of dropped objects in ACCOUNT_USAGE versus INFORMATION_SCHEMA?

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

Which statement is true about the handling of dropped objects in ACCOUNT_USAGE versus INFORMATION_SCHEMA?

Explanation:
The key idea is how Snowflake metadata sources differ between current state and history. ACCOUNT_USAGE is designed for auditing and long-term analysis, so its views retain information about objects that existed in the account, including those that were dropped, within the retention window. INFORMATION_SCHEMA, by contrast, reflects the live catalog and shows only objects that currently exist; once an object is dropped, it no longer appears in INFORMATION_SCHEMA views. This is why dropped objects can be seen in ACCOUNT_USAGE but not in INFORMATION_SCHEMA.

The key idea is how Snowflake metadata sources differ between current state and history. ACCOUNT_USAGE is designed for auditing and long-term analysis, so its views retain information about objects that existed in the account, including those that were dropped, within the retention window. INFORMATION_SCHEMA, by contrast, reflects the live catalog and shows only objects that currently exist; once an object is dropped, it no longer appears in INFORMATION_SCHEMA views. This is why dropped objects can be seen in ACCOUNT_USAGE but not in INFORMATION_SCHEMA.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy