SnowPro Core Certification — Question 679

The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)

Answer options

• 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

Correct answer: A, D

Explanation

The correct answers are A and D because the INFORMATION_SCHEMA provides views that represent all objects within the specific database and also includes table functions that relate to historical and usage data specific to that database. Options B and C refer to account-level views which are not part of the database-specific INFORMATION_SCHEMA, while option E relates to account-level objects, which again falls outside the scope of database-specific information.