Exam SnowPro Core topic 1 question 704 discussion

https://docs.snowflake.com/en/sql-reference/info-schema#what-is-information-schema

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

https://docs.snowflake.com/en/sql-reference/info-schema#what-is-information-schema AD

change to AE, after checked my snowflake account

I think AB

AD correct

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.

https://docs.snowflake.com/en/sql-reference/info-schema The info for account-level objects is represented in views

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.

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://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