
Answer-first summary for fast verification
Answer: Databases, Internal stages
The question specifically asks for objects for which the Information Schema provides 'storage information'. Based on Snowflake documentation and community consensus: - **B (Databases)**: The INFORMATION_SCHEMA.DATABASE_STORAGE_USAGE_HISTORY view provides storage metrics for databases. - **C (Internal stages)**: The INFORMATION_SCHEMA.STAGE_STORAGE_USAGE_HISTORY view provides storage information for stages, including internal stages. **Why other options are less suitable:** - **A (Users)**: Information Schema contains user metadata but not storage information. - **D (Resource monitors)**: Information Schema has resource monitor views but they track credit usage, not storage. - **E (Pipes)**: While INFORMATION_SCHEMA.PIPES exists, it provides metadata about pipe definitions and execution history, not storage information. Pipes don't store data themselves - they load data into tables. The community discussion shows strong consensus for BC (66% support), with key comments noting that 'storage information' specifically excludes pipes and focuses on actual storage objects like databases and stages.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.