The information schema provides storage information for which of the following objects? (Choose two.)
The information schema provides storage information for which of the following objects? (Choose two.)
The information schema provides storage information for Databases and Internal Stages. Databases have storage usage details which can be retrieved from INFORMATION_SCHEMA views. Internal stages, which are part of the staging area in database systems, also have their storage usage tracked and available in the 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.
Correctly, every DATABASE has his own INFORMATION_SCHEMA so A INFORMATION_SCHEMA has information about object of a SINGLe database, in this case: Internal stages Pipes So B, C
While the reasoning for the Database is clear. I don't understand how to choose between internal stages vs pipes. The Info Schema has views offering info on both stages and pipes.
BCE are correct
The answer is B & E https://docs.snowflake.com/en/sql-reference/info-schema information_schema contains views that hold metadata for - Databases, Stages(not Internal stages even though internal stage are examples of stages) and pipes. Therefore Databases and Pipes are the correct options.
correct ! i can see "DEMO_DB / INFORMATION_SCHEMA / PIPES" in information schema
Though Information_Schema provides the Pipes details, the question is about "Storage" Information. So only DB and Internal Stages will have Storage related information. If "Storage " is not used in the question, then Pipe is the 3rd answer.
DATABASE_STORAGE_USAGE_HISTORY STAGE_STORAGE_USAGE_HISTORY TABLE_STORAGE_METRICS There is no pipe storage usage is it does not involve storage
My opinion - BC E - Information schema gives PIPE usage information, not storage information.
Databases and internal stages
As per the document, BCE are correct. Don't know what to do in exam :P https://docs.snowflake.com/en/sql-reference/info-schema
B and C are correct
Databases,Schemas,Tables,Columns,Views: Stages: File Formats: Warehouses: Users and Roles: Privileges: Sequences: Resource Monitors:
Right answer is B,C, and D but they are asking for only two
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)
BC - based on the documentation, information schema displays view for database and account level objects as well as views for non-standard objects like Stages and File Formats. https://docs.snowflake.com/en/sql-reference/info-schema
definitions of databases and pipes. no internal stages.
DATABASE_STORAGE_USAGE_HISTORY STAGE_STORAGE_USAGE_HISTORY TABLE_STORAGE_METRICS
Correct
BCE should be correct, but I don't see any storage information in those views.