Free Practice Snowflake SnowPro-Core Exam Questions 2025

Stay ahead with 100% Free SnowPro Core Certification (COF-C02) SnowPro-Core Dumps Practice Questions

Page: 1 / 171

Total 851 Questions | Updated On: Apr 22, 2025

Add To Cart

Question 1

What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)

A : Stored procedures

B : Stages

C : Tasks

D : Views

E : User-Defined Functions (UDFs)

Answer: A,E

Question 2

When a database or a schema is cloned, which of the following statements are regarding Snowpipes in that database?

A : Any Snowpipes that reference an external stage are NOT cloned

B : Any Snowpipes that reference an internal stage are cloned

C : Any Snowpipes that reference an external stage are cloned

D : Any Snowpipes that reference an internal stage are NOT cloned

Answer: C,D

Question 3

True/False: Snowflake is based on existing database technology, which has been retrofitted to run on the cloud.

A : True

B : False

Answer: B

Question 4

What does a Query Profile metric that shows excessive spillage indicate?

A : Poor query optimization

B : Expired temporary tables

C : Improper virtual warehouse sizing

D : Improper Common Table Expressions (CTEs)

Answer: C

Question 5

What features does Snowflake Time Travel enable?

A : Querying data-related objects that were created within the past 365 days

B : Restoring data-related objects that have been deleted within the past 90 days

C : Conducting point-in-time analysis for Bl reporting

D : Analyzing data usage/manipulation over all periods of time

Answer: B,C

Page: 1 / 171

Total 851 Questions | Updated On: Apr 22, 2025

Add To Cart