Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

Changed COF-R02 Exam Questions

Page: 6 / 12
Question 24

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

Question 25

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Options:

A.

8-16 MB

B.

16-24 MB

C.

10-99 MB

D.

100-250 MB

Question 26

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Options:

A.

Grant the OWNERSHIP privilege on the schema.

B.

Grant the OWNERSHIP privilege on the database.

C.

Grant the MANAGE GRANTS global privilege.

D.

Grant ALL privileges on the schema.

Question 27

What is the maximum Time Travel retention period for a temporary Snowflake table?

Options:

A.

90 days

B.

1 day

C.

7 days

D.

45 days

Page: 6 / 12
Exam Code: COF-R02
Exam Name: SnowPro Core Recertification Exam
Last Update: May 2, 2024
Questions: 330
COF-R02 pdf

COF-R02 PDF

$28  $80
COF-R02 Engine

COF-R02 Testing Engine

$33.25  $95
COF-R02 PDF + Engine

COF-R02 PDF + Testing Engine

$45.5  $130