Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: merry71

Free SnowPro Core Recertification Exam Practice Questions

Question # 1

What is the minimum Snowflake edition required to create a materialized view?

Options:

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

Discussion 0
Question # 2

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Options:

A.  

True

B.  

False

Discussion 0
Question # 3

What is the MOST performant file format for loading data in Snowflake?

Options:

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

Discussion 0
Question # 4

What is the recommended file sizing for data loading using Snowpipe?

Options:

A.  

A compressed file size greater than 100 MB, and up to 250 MB

B.  

A compressed file size greater than 100 GB, and up to 250 GB

C.  

A compressed file size greater than 10 MB, and up to 100 MB

D.  

A compressed file size greater than 1 GB, and up to 2 GB

Discussion 0
Question # 5

Which of the following objects can be shared through secure data sharing?

Options:

A.  

Masking policy

B.  

Stored procedure

C.  

Task

D.  

External table

Discussion 0
Question # 6

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Options:

A.  

True

B.  

False

Discussion 0
Question # 7

Which command can be used to load data files into a Snowflake stage?

Options:

A.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

Discussion 0
Question # 8

Which formats does Snowflake store unstructured data in? (Choose two.)

Options:

A.  

GeoJSON

B.  

Array

C.  

XML

D.  

Object

E.  

BLOB

Discussion 0
Question # 9

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

A.  

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.  

An error will occur, as views with qualified references cannot be cloned.

C.  

An error will occur, as stored objects cannot be cloned.

D.  

The stored procedures and views will refer to tables in the source database.

Discussion 0
Question # 10

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Options:

A.  

Configure the warehouse to a size larger than generally required

B.  

Set the minimum and maximum clusters to autoscale

C.  

Use the standard warehouse scaling policy

D.  

Use the economy warehouse scaling policy

Discussion 0

COF-R02 PDF

COF-R02 PDF (Printable)
$46.5
$154.99

COF-R02 Testing Engine

COF-R02 PDF (Printable)
$51
$169.99

COF-R02 PDF + Testing Engine

COF-R02 PDF (Printable)
$63.9
$212.99
Exams4sure Dumps

Exam style questions across every COF-R02 domain

Last Update 4 days ago
Total Questions : 330

Start with our free COF-R02 practice questions, carefully crafted to mirror the domains, phrasing, and difficulty of the real SnowPro Core Certification exam. Each COF-R02 exam question comes with a detailed rationale that explains not just which answer is correct but why the others fall short. That's how concepts stick. Use the free set to benchmark yourself: identify your Snowflake weak domains, see where you're losing marks, and build a focused study plan in minutes.

Free Exams Sample Questions