Smartly Prepare Exam with Free Online SnowPro-Core Practice Test

We offer the latest SnowPro-Core practice test designed for free and effective online SnowPro Core Certification (COF-C02) certification preparation. It's a simulation of the real SnowPro-Core exam experience, built to help you understand the structure, complexity, and topics you'll face on exam day.

Question 1

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

Options :

A : A VARIANT column

B : A column with very low cardinality

C : A column with very high cardinality

D : A column that is most actively used in selective filters

E : A column that is most actively used in join predicates

Answer: C,D

Question 2

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options :

A : True

B : False

Answer: A

Question 3

When does a materialized view get suspended in Snowflake?

Options :

A : When a column is added to the base table

B : When a column is dropped from the base table

C : When a DML operation is run on the base table

D : When the base table is reclustered

Answer: B

Question 4

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options :

A : Compute resources

B : Query execution

C : Authentication

D : Data storage

E : Metadata

Answer: C,E

Question 5

Which view will show the MOST recent information about table-level storage utilization?

Options :

A : The TABLE_STORAGE_METRICS view in a Snowflake data share

B : The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema

C : The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA

D : The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA

Answer: B