COF-C02 · Question #656
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The correct answer is B. Tables C. Databases D. Internal Stages. Snowflake's INFORMATION_SCHEMA and ACCOUNT_USAGE schema track storage consumption for: Tables (B) - via TABLE_STORAGE_METRICS and TABLES views; Databases (C) - aggregated storage per database; Internal Stages (D) - via STAGE_STORAGE_USAGE_HISTORY. Users (A) are not storage…
Question
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Options
- AUsers
- BTables
- CDatabases
- DInternal Stages
How the community answered
(27 responses)- A7% (2)
- B93% (25)
Explanation
Snowflake's INFORMATION_SCHEMA and ACCOUNT_USAGE schema track storage consumption for: Tables (B) - via TABLE_STORAGE_METRICS and TABLES views; Databases (C) - aggregated storage per database; Internal Stages (D) - via STAGE_STORAGE_USAGE_HISTORY. Users (A) are not storage objects - they are identity/access entities and do not consume storage that would be reported in storage views. Storage tracking in Snowflake is relevant to objects that physically hold data, which excludes user accounts.
Topics
Community Discussion
No community discussion yet for this question.