Answer-first summary for fast verification
Answer: Views for all the objects contained in the database, Table functions for historical and usage data across the Snowflake account
According to Snowflake's official documentation, each database includes an INFORMATION_SCHEMA with: (1) Views for all objects contained in the database, as well as views for account-level objects (roles, warehouses, databases), and (2) Table functions for historical and usage data across the account. Option A correctly identifies views for database objects, and option D correctly identifies table functions for historical and usage data. Option B is incorrect because views are not for 'all objects in the Snowflake account' but specifically for database objects and account-level objects. Option C is incorrect because there are no views for historical data; this is handled by table functions. Option E is incorrect because table functions are for historical/usage data, not account-level objects (which are covered by views). The community discussion shows AD as the most upvoted answer (53%) with direct documentation references, confirming A and D as correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two types of objects are contained within the INFORMATION_SCHEMA of every database?
A
Views for all the objects contained in the database
B
Views for all the objects contained in the Snowflake account
C
Views for historical and usage data across the Snowflake account
D
Table functions for historical and usage data across the Snowflake account
E
Table functions for account-level objects, such as roles, virtual warehouses, and databases
No comments yet.