
Answer-first summary for fast verification
Answer: Tables, Databases, Internal Stages
The question specifically asks for object types that have storage information available in BOTH the Information Schema and Account Usage share. Based on the community discussion and Snowflake documentation: - **B (Tables)**: Storage information is available in both schemas (e.g., TABLE_STORAGE_METRICS in ACCOUNT_USAGE and INFORMATION_SCHEMA). - **C (Databases)**: Storage information is available in both schemas (e.g., DATABASE_STORAGE_USAGE_HISTORY in ACCOUNT_USAGE and INFORMATION_SCHEMA). - **D (Internal Stages)**: Storage information is available in both schemas (e.g., STAGE_STORAGE_USAGE_HISTORY in ACCOUNT_USAGE and STAGES view in INFORMATION_SCHEMA). **A (Users) is incorrect** because while user information exists in ACCOUNT_USAGE (USERS view), there is no storage information specifically for users in either schema. Users don't consume storage themselves - storage is associated with objects like tables, databases, and stages that users create or own. The community consensus (87% selected BCD) and detailed comments confirm that user storage information is not available.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.