SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 260


The information schema provides storage information for which of the following objects? (Choose two.)

Show Answer
Correct Answer: BC

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.

Discussion

17 comments
Sign in to comment
Kate0204
Dec 7, 2022

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.

BigDataBB
Jan 19, 2023

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

SV1122Options: BE
Dec 30, 2022

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.

EmiB
Mar 11, 2023

BCE are correct

SteveCrownOptions: BE
May 21, 2023

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.

NEMMELA
Sep 7, 2023

correct ! i can see "DEMO_DB / INFORMATION_SCHEMA / PIPES" in information schema

RajivnbOptions: BC
Oct 12, 2023

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.

isolated_sniperOptions: BC
Apr 30, 2023

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

Ram9198Options: BC
Nov 1, 2023

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

dmitriypo
May 10, 2023

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

MultiCloudIronManOptions: BC
Jul 13, 2023

Correct

singhksOptions: BC
Aug 19, 2023

DATABASE_STORAGE_USAGE_HISTORY STAGE_STORAGE_USAGE_HISTORY TABLE_STORAGE_METRICS

Marge23Options: BE
Sep 18, 2023

definitions of databases and pipes. no internal stages.

nonamaeOptions: BC
Oct 9, 2023

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

Ram9198Options: CE
Oct 31, 2023

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)

Afzy
Nov 1, 2023

Right answer is B,C, and D but they are asking for only two

Afzy
Nov 1, 2023

Databases,Schemas,Tables,Columns,Views: Stages: File Formats: Warehouses: Users and Roles: Privileges: Sequences: Resource Monitors:

_yyuktaOptions: BC
Feb 26, 2024

B and C are correct

Sarav13Options: BC
Mar 24, 2024

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

Mallikharjuna452Options: BC
Jul 22, 2024

Databases and internal stages