SOL-C01 · Question #229
SOL-C01 Question #229: Real Exam Question with Answer & Explanation
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.
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.