Question 1

Which command can be used to query the Information Schema in Snowflake to retrieve a list of tables?

Options :

A : SELECT * FROM PUBLIC.INFORMATION_SCHEMA;

B : SELECT * FROM INFORMATION_SCHEMA.COLUMNS;

C : SELECT * FROM INFORMATION_SCHEMA.TABLES;

D : SELECT * FROM PUBLIC.TABLES;

Answer: C

Question 2

What filter can be used when searching for data products on the Snowflake Marketplace?

Options :

A : Size

B : Compatibility

C : Price

D : Performance

Answer: C

Question 3

What is the Snowsight object browser used for?

Options :

A : To manage virtual warehouses

B : To create Snowsight worksheets

C : To modify security settings for objects

D : To view and filter database objects

Answer: D

Question 4

What is the SHOW GRANTS SQL command primarily used for?

Options :

A : To view the history of data loads.

B : To display all privileges granted to a role or user.

C : To list all active users in the account.

D : To show current warehouse credit usage.

Answer: B

Question 5

What is the main characteristic of Snowflake's Standard Edition?

Options :

A : Offers unlimited Time Travel history.

B : Includes Business Critical features like HIPAA compliance.

C : Supports Private Connectivity (AWS PrivateLink, Azure Private Link).

D : Provides core Snowflake features for data warehousing and analytics.

Answer: D

Free SOL-C01 Mock Exam – Practice Online Confidently