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

4 months 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

4 months 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

Melita

3 months ago

It's definitely a risk giving that much access, hopefully the 'CONSUMER' uses it responsibly.

upvoted 0 times

...

Luke

3 months ago

I wonder if the provider has any safeguards in place to prevent any misuse of the data.

upvoted 0 times

...

Jesusa

3 months ago

I know right! That's a lot of access for someone without their own Snowflake account.

upvoted 0 times

...

Lino

4 months ago

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

upvoted 0 times

Rima

3 months ago

D) The reader account can create a copy of the shared data using CREATE TABLE AS...

upvoted 0 times

...

Margurite

3 months ago

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

upvoted 0 times

...

Carlee

3 months ago

B) The reader account compute will be billed to the provider account.

upvoted 0 times

...

Lavonna

4 months 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

Georgeanna

3 months ago

Good point. The provider should consider the implications of allowing the reader account to create copies of the shared data.

upvoted 0 times

...

Inocencia

3 months ago

But wouldn't that also mean they could potentially misuse the data if they create copies?

upvoted 0 times

...

Letha

4 months ago

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

upvoted 0 times

...

Krystal

4 months 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

5 months ago

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

upvoted 0 times

...

Laura

5 months 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

Ashlyn

4 months ago

I agree. It's important to have these restrictions in place to protect sensitive information.

upvoted 0 times

...

Titus

4 months ago

D) The reader account can create a copy of the shared data using CREATE TABLE AS...

upvoted 0 times

...

Nieves

4 months ago

Definitely, it helps maintain security and privacy for the data being shared.

upvoted 0 times

...

Shawnee

4 months ago

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

upvoted 0 times

...

Chantell

4 months ago

That makes sense. It's good that the provider has control over what the consumer can do with the shared data.

upvoted 0 times

...

Ma

4 months ago

B) The reader account compute will be billed to the provider account.

upvoted 0 times

...

Tran

4 months 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

5 months ago

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

upvoted 0 times

...

Delisa

5 months ago

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

upvoted 0 times

...