SOL-C01 · Question #229
A data consumer creates a database 'DB CONSUMER from a share provided through Snowflake Data Sharing. After some time, the data provider revokes access to the share. What is the state of 'DB CONSUMER'
The correct answer is B. 'DB CONSUMER becomes inaccessible, and all queries against it will fail.. When access to a share is revoked, the database created from that share becomes inaccessible. Snowflake's data sharing relies on a live connection to the provider; when the connection is broken, the data is no longer available to the consumer.
Question
A data consumer creates a database 'DB CONSUMER from a share provided through Snowflake Data Sharing. After some time, the data provider revokes access to the share. What is the state of 'DB CONSUMER'?
Options
- A'DB CONSUMER remains accessible, but new data updates from the provider are not reflected.
- B'DB CONSUMER becomes inaccessible, and all queries against it will fail.
- C'DB CONSUMER is automatically dropped.
- DCONSUMER becomes read-only with the data available at the time access was revoked.
- E'DB CONSUMER is still accessible but data is masked.
How the community answered
(51 responses)- B92% (47)
- C4% (2)
- D2% (1)
- E2% (1)
Explanation
When access to a share is revoked, the database created from that share becomes inaccessible. Snowflake's data sharing relies on a live connection to the provider; when the connection is broken, the data is no longer available to the consumer.
Topics
Community Discussion
No community discussion yet for this question.