Which of the below statements are true?

Which of the below statements are true?
A . ACCOUNT USAGE includes dropped objects but INFORMATION SCHEMA does not
B. INFORMATION SCHEMA includes dropped objects but ACCOUNT USAGE does not
C. BOTH includes dropped object
D. BOTH does not include dropped object

View Answer

Answer: A

Explanation

https://docs.snowflake.com/en/sql-reference/account-usage.html#differences-between-account-usage-and-information-schema

Dropped Object Records

Account usage views include records for all objects that have been dropped. An additional DELETED column displays the timestamp when the object was dropped.

In addition, because objects can be dropped and recreated with the same name, to differentiate between objects records that have the same name, the account usage views include ID columns, where appropriate, that display the internal IDs generated and assigned to each record by the system.