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?

Question

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?

Francesco MARRELLA · Accepted Answer

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

Francesco MARRELLA · Answer

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

Francesco MARRELLA · Answer

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

Francesco MARRELLA · Answer

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

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 227 - COF-C02 discussion

Suggested answer: B

0 comments