Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Snowflake SnowPro Core Certification COF-R02 New Questions

Page: 5 / 12
Total 330 questions

SnowPro Core Recertification Exam Questions and Answers

Question 17

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options:

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Question 18

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Options:

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Question 19

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

A.

Time Travel - 1 day. Fail-safe - 1 day

B.

Time Travel - 0 days. Fail-safe - 1 day

C.

Time Travel - 1 day. Fail-safe - 0 days

D.

Transient tables are retained in neither Fail-safe nor Time Travel

Question 20

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

Page: 5 / 12
Total 330 questions