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 # 11

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

A.

The Pipe load history is reset to empty

B.

The REFRESH parameter is set to TRUE

C.

Previously loaded files will be ignored

D.

All of the above

Question # 12

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

E.

1 year

Question # 13

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

A.

Caching query results

B.

Running EXPLAIN and SHOW commands

C.

Cloning a database

D.

Running a custom query

E.

Running COPY commands

Question # 14

Which of the following are characteristics of security in Snowflake?

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.

Question # 15

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.

When the data cache is full, the least-recently used data will be cleared to make room.

C.

A user can only access their own queries from the query result cache.

D.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Question # 16

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A.

STRIP_NULL_VALUES

B.

SKIP_BYTE_ORDER_MARK

C.

REPLACE_INVALID_CHARACTERS

D.

VALIDATION_MODE

Question # 17

Where would a Snowflake user find information about query activity from 90 days ago?

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Question # 18

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

A.

True

B.

False

Question # 19

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Question # 20

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Go to page: