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: 1 / 5
Total 330 questions

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

A.

Data is hashed by the cluster key to facilitate fast searches for common data values

B.

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.

Smaller micro-partitions are created for common data values to allow for more parallelism

D.

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Which of the following describes how clustering keys work in Snowflake?

A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.

Clustering keys sort the designated columns over time, without blocking DML operations

C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

A.

Materialized views

B.

Sequences

C.

Procedures

D.

Tables

E.

Secure User Defined Functions (UDFs)

How often are encryption keys automatically rotated by Snowflake?

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

True or False: A Virtual Warehouse can be resized while suspended.

A.

True

B.

False

Which data type can be used to store geospatial data in Snowflake?

A.

Variant

B.

Object

C.

Geometry

D.

Geography

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A.

A single join node uses more than 50% of the query time

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Which command can be used to stage local files from which Snowflake interface?

A.

SnowSQL

B.

Snowflake classic web interface (Ul)

C.

Snowsight

D.

.NET driver

What feature can be used to reorganize a very large table on one or more columns?

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

What happens when a virtual warehouse is resized?

A.

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B.

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

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

True or False: Snowpipe via REST API can only reference External Stages as source.

A.

True

B.

False

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A.

4

B.

8

C.

16

D.

32

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

A.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A.

Gathering the hourly credit usage for an account

B.

Compiling an account's average cloud services cost over the previous month

C.

Summarizing the throughput of Snowpipe costs for an account

D.

Calculating the funds left on an account's contract

Which of the following accurately describes shares?

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO

command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

A.

Compress the file and load the compressed file.

B.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

A.

Row level access policies

B.

Data masking policies

C.

Data encryption

D.

Time Travel

E.

External tokenization

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

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