Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Lematthew31
2 weeks, 4 days ago0e504b5
3 months agoRam9198
6 months, 4 weeks agokayuhanbiduk
7 months agokayuhanbiduk
7 months agokayuhanbiduk
7 months agoHeetec
7 months agoAmitsnowflake
7 months, 4 weeks agopvskbrod
8 months, 1 week agoJG1984
8 months, 2 weeks agosinghks
9 months agoukpino
10 months agoMultiCloudIronMan
10 months, 1 week agohappykeieiekek
10 months, 1 week ago