Snowpro Core · Free Practice Question Easy
Question 4
True or False: The ACCOUNT_USAGE views contain information on objects that have been deleted.
- A True
- B False
Reveal correct answer
Correct answer: A
Explanation
ACCOUNT_USAGE views include information for all dropped objects. Many of these views include a DELETED column showing the dropped object's information. INFORMATION_SCHEMA does not include dropped objects. Furthermore, because objects can be dropped and recreated with the same name, the account use views include ID columns that display the internal IDs generated and assigned to each object by the system to differentiate amongst object records with the same name. https://docs.snowflake.com/en/sql-reference/account-usage#differences-between-account-usage-and-information-schemaDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
