Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

COF-R02 Snowflake SnowPro Core Recertification Exam Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Snowflake COF-R02 SnowPro Core Recertification Exam certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Snowflake COF-R02 Premium Access     Download Demo    
Page: 3 / 5
Total 330 questions

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

A.

1 second

B.

60 seconds

C.

5 minutes

D.

60 minutes

What affects whether the query results cache can be used?

A.

If the query contains a deterministic function

B.

If the virtual warehouse has been suspended

C.

If the referenced data in the table has changed

D.

If multiple users are using the same virtual warehouse

What happens to historical data when the retention period for an object ends?

A.

The data is cloned into a historical object.

B.

The data moves to Fail-safe

C.

Time Travel on the historical data is dropped.

D.

The object containing the historical data is dropped.

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A.

A multi-cluster Warehouse can add clusters automatically based on query activity

B.

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

C.

A multi-cluster Warehouse can scale down when query activity slows

D.

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

True or False: You can query the files in an External Stage directly without having to load the data into a table.

A.

True

B.

False

Which of the following statements would be used to export/unload data from Snowflake?

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Which of the following statements is true of Snowflake?

A.

It was built specifically for the cloud

B.

It was built as an on-premises solution and then ported to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

A.

True

B.

False

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A.

True

B.

False

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

A.

More micro-partitions

B.

Better query scheduling

C.

Double the numbers of servers In the compute duster

D.

Higher storage costs

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A.

True

B.

False

Which of the following terms best describes Snowflake’s database architecture?

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?

(Choose all that apply.)

A.

Growth of storage and compute are tightly coupled together

B.

Storage expands without the requirement to add more compute

C.

Compute can be scaled up or down without the requirement to add more storage

D.

Multiple compute clusters can access stored data without contention

When can a Virtual Warehouse start running queries?

A.

12am-5am

B.

Only during administrator defined time slots

C.

When its provisioning is complete

D.

After replication

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

A.

The complexity of each query

B.

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

C.

The size of the data required for each query

D.

The tool that s executing the query

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A.

True

B.

False

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

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

A.

True

B.

False

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

A.

True

B.

False

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

A.

Number of users

B.

Warehouse size

C.

Amount of data processed

D.

# of clusters for the Warehouse

Snowflake COF-R02 Premium Access     Download Demo    
Page: 3 / 5
Total 330 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved