Snowflake Exam COF-R02 Topic 1 Question 36 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 36
Topic #: 1

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 Margurite at Jul 09, 2024, 02:15 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Therese

5 months ago

Alright, let's see here... The provider is creating a special account just for the consumer, that's interesting. I'll go with D, the ability to clone the data sounds pretty useful.

upvoted 0 times

Gary

3 months ago

Yeah, having the ability to create a copy of the shared data seems like a useful feature.

upvoted 0 times

...

Juan

3 months ago

I agree, being able to clone the data gives the consumer more flexibility in how they use it.

upvoted 0 times

...

Lorrie

3 months ago

I think D is the correct answer too. Cloning the data can be really helpful.

upvoted 0 times

...

Nida

4 months ago

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

upvoted 0 times

...

Lashunda

4 months ago

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

upvoted 0 times

...

Alecia

5 months ago

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

upvoted 0 times

...

Lino

5 months ago

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

upvoted 0 times

...

Melodie

5 months ago

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

upvoted 0 times

...

Felicitas

5 months ago

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

upvoted 0 times

...

Tamra

5 months ago

Hmm, I'm not sure about this one. Can the reader account access any other data besides the shared data? I might have to go with B just to be safe.

upvoted 0 times

Willodean

5 months ago

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

upvoted 0 times

...

Leota

5 months ago

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

upvoted 0 times

...

Benton

6 months ago

Wait, so the provider is just giving away their data for free? How generous of them! I'll take option C, that sounds like the best deal for me.

upvoted 0 times

Kimi

5 months ago

Just remember, you can't share it with others, so make the most of the data you have access to.

upvoted 0 times

...

Ruth

5 months ago

It's a good deal for you as the consumer, you can work with the data without having to pay for it.

upvoted 0 times

...

Rene

5 months ago

Option C is correct, you can clone the data but you won't be able to re-share it.

upvoted 0 times

...

Hortencia

5 months ago

That's right, the provider is being very generous by sharing their data with you.

upvoted 0 times

...

Tamie

6 months ago

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

upvoted 0 times

...

Derick

6 months ago

I think the reader account will automatically use the Standard edition of Snowflake.

upvoted 0 times

...