The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The Information Schema and Account Usage Share provide storage information for Tables, Databases, and Internal Stages. Storage information is typically relevant to objects that hold data. Users do not fall into this category as they do not require storage for data but rather for metadata and roles. Therefore, the correct options are Tables, Databases, and Internal Stages.
Couldn't find any information where storage of a user is explained/showed. Tables in Account Usage view related to storage are (database, stage, table): DATABASE_STORAGE_USAGE_HISTORY, STAGE_STORAGE_USAGE_HISTORY, STORAGE_USAGE, TABLE_STORAGE_METRICS
We can get User info too. The Account Usage view can be used to query a list of all users in the account. The data is retained for 365 days (1 year). https://docs.snowflake.com/en/sql-reference/account-usage/users.html
Probably BCD Because users are not "storage information" as mentioned in the question
I belive all fours, as I saw in the documentation. https://docs.snowflake.com/en/sql-reference/account-usage
BCD. Could not find user information in Information Schema.
correct
Internal Stages comsume storage and the storage consumed can be found in the SNOWFLAKE.ACCOUNT_USAGE.STAGE_STORAGE_USAGE_HISTORY. Storage consumed by tables and databases can be found in SNOWFLAKE.ACCOUNT_USAGE.TABLE_STORAGE_METRICS in which we have the table name and the database name included in them.
No user level
BCD ARE CORRECT
BCD are correct
DATABASE_STORAGE_USAGE_HISTORY, STAGE_STORAGE_USAGE_HISTORY, STORAGE_USAGE, TABLE_STORAGE_METRICS
It store view for all object contained in the database as well as view for account level objects such as role warehouse It store table functions for historical and usage data across your account. Select * from table (infirmation_schema.login_history_by_user(USER_NAME => 'user')) gives you login user information
A is also one of the correct option.There are table functions stored in information schema which can be used to get historical information for storage, warehouse, user logins and queries. Login_history, login_history_by_user (data retention 7 days)
ABC SNOWFLAKE VIEWS: USERS, DATABASES, SCHEMATA AND TABLES NO INTERNAL STAGES.
The question is related to "Storage Information". Users do not have storage either as an object or data they hold (roles own items). Therefore users is not an option.
Correct answer is ABC. users is the one holding for the account.
Snowflake Information Schema: Stages, External Tables and Pipes,Databases, Schema, Tables and Views,Columns and Constraints and many more
Well, having painstakingly checked the 2 schema, both information_schema and account_usage hvae Tables, Databases and stages. Though there is the USERS VIEW in account_usage schema, there is no such view in INFORMATION _SCHEMA. Therefore, I will argue that B,C,D are correct.
Ans is ABC. As I can see only external stages while running below query: select * from SNOWFLAKE.ACCOUNT_USAGE.STAGES; I am able to get the user details using below query select * from SNOWFLAKE.ACCOUNT_USAGE.USERS ;
I found information that supports all answers ABCD. This is confusing.
select * from snowflake.information_schema.views where table_name like '%STORAGE%' and table_schema in ('ACCOUNT_USAGE','INFORMATION_SCHEMA'); TABLE_CATALOG TABLE_SCHEMA TABLE_NAME SNOWFLAKE ACCOUNT_USAGE DATABASE_STORAGE_USAGE_HISTORY SNOWFLAKE ACCOUNT_USAGE STAGE_STORAGE_USAGE_HISTORY SNOWFLAKE ACCOUNT_USAGE STORAGE_USAGE SNOWFLAKE ACCOUNT_USAGE TABLE_STORAGE_METRICS SNOWFLAKE INFORMATION_SCHEMA TABLE_STORAGE_METRICS