In Snowflake, which usage schema includes dropped objects that Information Schema does not?

• A. Account Usage
• B. Organization Usage
• C. Data Sharing Usage
• D. Information Schema

Answer: (A)

The thing being tested is where Snowflake stores historical metadata for auditing, specifically objects that have been dropped. Information Schema shows metadata for objects that currently exist, so it won’t include items that were deleted. Account Usage, on the other hand, is designed for governance across the entire account and retains historical metadata, including dropped objects. This makes it the source that lets you see what existed even after it was dropped, which Information Schema does not provide. The other usage schemas are geared toward organization-wide governance or data-sharing metadata and don’t focus on preserving the history of dropped objects. That’s why Account Usage is the best fit.