The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)
The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)
Each database created in your Snowflake account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. This schema contains views for all the objects contained in the database, ensuring that users can easily query metadata related to their database tables, views, functions, and other objects. Additionally, INFORMATION_SCHEMA includes table functions for historical and usage data across the Snowflake account, allowing users to perform queries that return information about the account's usage patterns and historical data. These table functions are crucial for monitoring and auditing the performance and activities within the Snowflake account.
https://docs.snowflake.com/en/sql-reference/info-schema The info for account-level objects is represented in views
What is INFORMATION_SCHEMA?¶ Each database created in your account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. The schema contains the following objects: Views for all the objects contained in the database, as well as views for account-level objects (i.e. non-database objects such as roles, warehouses, and databases) Table functions for historical and usage data across your account. https://docs.snowflake.com/en/sql-reference/info-schema
https://docs.snowflake.com/en/sql-reference/info-schema#what-is-information-schema AD
AD correct
https://www.bing.com/search?q=The+INFORMATION_SCHEMA+included+in+each+database+contains+which+objects%3F+&qs=n&form=QBRE&sp=-1&lq=1&pq=the+information_schema+included+in+each+database+contains+which+objects%3F+&sc=1-73&sk=&cvid=3A669149F6174EEC998D5F100E03D6D2&ghsh=0&ghacc=0&ghpl=
Answer is A & D
I have check and it seems to be A & E ...
I vote AD. https://docs.snowflake.com/en/sql-reference/info-schema Each database created in your account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. The schema contains the following objects: Views for all the objects contained in the database, as well as views for account-level objects (i.e. non-database objects such as roles, warehouses, and databases) Table functions for historical and usage data across your account. The table functions in INFORMATION_SCHEMA can be used to return account-level usage and historical information for storage, warehouses, user logins, and queries: AD directly matches docs E is not correct. There are no roles table functions
change to AE, after checked my snowflake account
I think AB
change to AE, after check my snowflake account
A,B,D,E are correct ans. There are no view for historic data. There are table functions but not views. Thats why C is not correct.
The INFORMATION_SCHEMA is a set of views that provide metadata about the objects in a Snowflake database. It includes views for all the tables, views, columns, functions, and other objects in the database. It also includes views for account-level objects, such as roles, virtual warehouses, and databases.
AD https://docs.snowflake.com/en/sql-reference/info-schema Each database created in your account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. The schema contains the following objects: Views for all the objects contained in the database, as well as views for account-level objects (i.e. non-database objects such as roles, warehouses, and databases) Table functions for historical and usage data across your account.