Answer-first summary for fast verification
Answer: The object immediately becomes unavailable for all Data Consumers.
Option A is correct because when a Data Provider revokes privileges on a shared object from a share, the object immediately becomes unavailable for all Data Consumers. This aligns with Snowflake's secure data sharing mechanism where access is controlled through privileges. The community discussion strongly supports A with 100% consensus and upvoted comments explaining that revoking privileges effectively removes objects from the share, disabling access in all consumer accounts. Option B is incorrect because it's not about future data visibility but immediate access revocation. Option C is wrong as Data Consumers don't incur storage charges for shared objects. Option D is incorrect because no static copy is created in the consumer's account; access is simply revoked.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When a Data Provider revokes privileges on a shared object from a share in the source database, what is the outcome?
A
The object immediately becomes unavailable for all Data Consumers.
B
Any additional data arriving after this point in time will not be visible to Data Consumers.
C
The Data Consumers stop seeing data updates and become responsible for storage charges for the object.
D
A static copy of the object at the time the privilege was revoked is created in the Data Consumers account.