Exam SnowPro Core topic 1 question 260 discussion

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.

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.

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

DATABASE_STORAGE_USAGE_HISTORY STAGE_STORAGE_USAGE_HISTORY TABLE_STORAGE_METRICS There is no pipe storage usage is it does not involve storage

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)

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.

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

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.

BCE should be correct, but I don't see any storage information in those views.

My opinion - BC E - Information schema gives PIPE usage information, not storage information.