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

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A.

True

B.

False

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

A.

True

B.

False

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

A.

True

B.

False

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

A.

Compute

B.

Tri-Secret Secure

C.

Storage

D.

Cloud Services

The PUT command: (Choose two.)

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

A.

True

B.

False

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

A.

True

B.

False

Which of the following are options when creating a Virtual Warehouse?

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Which of the following objects is not covered by Time Travel?

A.

Tables

B.

Schemas

C.

Databases

D.

Stages

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

Select the different types of Internal Stages: (Choose three.)

A.

Named Stage

B.

User Stage

C.

Table Stage

D.

Schema Stage

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

A.

To accommodate more queries

B.

To accommodate more users

C.

To accommodate fluctuations in workload

D.

To accommodate a more complex workload

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

What privileges are required to create a task?

A.

The global privilege create task is required to create a new task.

B.

Tasks are created at the Application level and can only be created by the Account Admin role.

C.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

D.

The role must have access to the target schema and the create task privilege on the schema itself.

True or False: A single database can exist in more than one Snowflake account.

A.

True

B.

False

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

What SQL command would be used to view all roles that were granted to user.1?

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A.

The user has the appropriate privileges on the objects associated with the query

B.

Micro-partitions have been reclustered since the query was last run

C.

The new query is run using the same virtual warehouse as the previous query

D.

The query includes a User Defined Function (UDF)

E.

The query has been run within 24 hours of the previously-run query

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

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