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

Sang

14 days ago

This is a tricky one, but I think B is the way to go. The provider is responsible for the reader account's costs.

upvoted 0 times

...

Mila

16 days ago

Haha, the provider must really trust this 'CONSUMER' dude to give them that kind of access. I hope they don't pull a fast one!

upvoted 0 times

...

Lino

20 days ago

B is the correct answer. The provider is footing the bill for the reader account's compute resources.

upvoted 0 times

...

Lavonna

28 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

Letha

3 days ago

That's true. It would give the consumer more flexibility in how they use the data.

upvoted 0 times

...

Krystal

8 days ago

I think option D makes sense. It would be useful for the reader account to create a local copy of the shared data.

upvoted 0 times

...

Art

1 months ago

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

upvoted 0 times

...

2 months ago

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

upvoted 0 times

...