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.
