Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

SnowPro Core Recertification Exam

Last Update 8 hours ago Total Questions : 330

The SnowPro Core Recertification Exam content is now fully updated, with all current exam questions added 8 hours ago. Deciding to include COF-R02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our COF-R02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these COF-R02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Core Recertification Exam practice test comfortably within the allotted time.

Question # 91

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

A.

True

B.

False

Question # 92

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

Question # 93

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

A.

True

B.

False

Question # 94

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

Question # 95

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

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Question # 96

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);

Question # 97

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

A.

True

B.

False

Question # 98

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Question # 99

Which of the following objects are contained within a schema? (Choose two.)

A.

Role

B.

Stream

C.

Warehouse

D.

External table

E.

User

F.

Share

Go to page: