Snowflake
COF-R02 · Question #303
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…
The correct answer is C. The reader account can clone data the provider has shared, but cannot re-share it. See the full explanation below for the reasoning.
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?
Options
- 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...
How the community answered
(16 responses)- A6% (1)
- B6% (1)
- C75% (12)
- D13% (2)
Community Discussion
No community discussion yet for this question.