Snowflake Exam COF-R02 Topic 2 Question 46 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 46
Topic #: 2

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

AThe reader account will automatically use the Standard edition of Snowflake.

BThe reader account compute will be billed to the provider account.

CThe reader account can clone data the provider has shared, but cannot re-share it.

DThe reader account can create a copy of the shared data using CREATE TABLE AS...

Show Suggested Answer

Suggested Answer: C

by Mable at Oct 19, 2024, 03:17 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lavonna

5 days ago

I'm leaning towards option D. Seems like the reader account should be able to create a local copy of the shared data for their own use.

upvoted 0 times

...

Art

20 days ago

I believe the reader account compute will be billed to the provider account.

upvoted 0 times

...

Laura

21 days ago

Option C sounds about right. The reader account can view and query the shared data, but can't do anything too crazy with it.

upvoted 0 times

Rosalia

13 days ago

A) The reader account will automatically use the Standard edition of Snowflake.

upvoted 0 times

...

Delisa

28 days ago

I think the reader account can clone data but not re-share it.

upvoted 0 times

...