Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 5

Questions 41

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Options:
A.

Files

B.

External tables

C.

Secure User-Defined Functions (UDFs)

D.

Sequences

E.

Streams

Snowflake COF-R02 Premium Access
Questions 42

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:
A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Questions 43

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Options:
A.

Create a zero-copy clone of the worksheet and grant permissions to teammates

B.

Create a private Data Exchange so that any teammate can use the worksheet

C.

Share the worksheet with teammates within Snowsight

D.

Create a database and grant all permissions to teammates

Questions 44

How many resource monitors can be assigned at the account level?

Options:
A.

1

B.

2

C.

3

D.

4

Questions 45

Which of the following statements describes a schema in Snowflake?

Options:
A.

A logical grouping of objects that belongs to a single database

B.

A logical grouping of objects that belongs to multiple databases

C.

A named Snowflake object that includes all the information required to share a database

D.

A uniquely identified Snowflake account within a business entity

Questions 46

How can a row access policy be applied to a table or a view? (Choose two.)

Options:
A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;

Questions 47

When loading data into Snowflake, how should the data be organized?

Options:
A.

Into single files with 100-250 MB of compressed data per file

B.

Into single files with 1-100 MB of compressed data per file

C.

Into files of maximum size of 1 GB of compressed data per file

D.

Into files of maximum size of 4 GB of compressed data per file

Questions 48

Which of the following are characteristics of security in Snowflake?

Options:
A.

Account and user authentication is only available with the Snowflake Business Critical edition.

B.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Questions 49

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options:
A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Questions 50

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?

Options:
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.

Exam Code: COF-R02
Certification Provider: Snowflake
Exam Name: SnowPro Core Recertification Exam
Last Update: Jul 17, 2025
Questions: 330

Snowflake Related Exams

How to pass Snowflake SnowPro-Core - SnowPro Core Certification Exam Exam
How to pass Snowflake COF-C02 - SnowPro Core Certification Exam Exam
DEA-P02 - Practice Exam: Data Engineer- ENGLISH ONLY
ARA-R01 - SnowPro Advanced: Architect Recertification Exam
ADA-R01 - SnowPro Advanced: Administrator Recertification Exam
NAS-B01 - SnowPro Specialty: Native Apps Beta Certification Exam
DSA-C03 - SnowPro Advanced: Data Scientist Certification Exam
DSA-C02 - SnowPro Advanced: Data Scientist Certification Exam
DAA-R01 - SnowPro Advanced: Data Analyst Recertification Exam
SOL-C01 - SnowPro Associate: Platform Certification Exam
ARA-P01 - Practice Exam: Architect
DEA-C02 - SnowPro Advanced: Data Engineer Certification Exam - ENGLISH ONLY
DEA-R01 - SnowPro Advanced: Data Engineer Recertification Exam
ADA-B01 - SnowPro Advanced: Administrator Certification Exam
DAA-P01 - Practice Exam: Data Analyst
Snowflake Free Access
Get Snowflake Full Access

Snowflake Free Exams
Snowflake Free Exams
Access free Snowflake exam study guides and practice tests at Examstrack. Ensure your success with top-notch preparation resources at Examstrack.