Free Practice Snowflake COF-R02 Exam Questions 2025

Stay ahead with 100% Free SnowPro Core Recertification COF-R02 Dumps Practice Questions

Page: 1 / 67

Total 333 Questions | Updated On: Apr 10, 2025

Add To Cart

Question 1

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 2

During periods of warehouse contention which parameter controls the maximum length of time a warehouse

will hold a query for processing?

A : STATEMENT_TIMEOUT__IN__SECONDS

B : STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C : MAX_CONCURRENCY__LEVEL

D : QUERY_TIMEOUT_IN_SECONDS

Answer: B

Question 3

True or False: Data Providers can share data with only the Data Consumer.

A : True

B : False

Answer: B

Question 4

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A : The ability to scale up warehouses

B : The use of warehouse auto scaling

C : The ability to resize warehouses

D : Use of multi-clustered warehouses

E : The use of warehouse indexing

Answer: B,D

Question 5

A materialized view should be created when which of the following occurs? (Choose two.)

A : There is minimal cost associated with running the query.

B : The query consumes many compute resources every time it runs.

C : The base table gets updated frequently.

D : The query is highly optimized and does not consume many compute resources.

E : The results of the query do not change often and are used frequently.

Answer: A,C

Page: 1 / 67

Total 333 Questions | Updated On: Apr 10, 2025

Add To Cart