Learn about the INFORMATION_SCHEMA views available in Snowflake databases, including table functions for account-level objects, and how to use them to access metadata about database objects.
Table of Contents
Question
The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)
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
Answer
A. Views for all the objects contained in the database
E. Table functions for account-level objects, such as roles, virtual warehouses, and databases
Explanation
The INFORMATION_SCHEMA included in each Snowflake database contains information about the objects within that specific database. The INFORMATION_SCHEMA views provide a way to access metadata about the objects in the database, such as their schema, data types, and relationships.
The correct answers are:
E. Table functions for account-level objects, such as roles, virtual warehouses, and databases
The INFORMATION_SCHEMA views do not contain information about views for all the objects contained in the Snowflake account or historical and usage data across the Snowflake account. These types of views are not available in the INFORMATION_SCHEMA.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.