Answer-first summary for fast verification
Answer: The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
Option C is correct because when objects are deleted from the data share by the provider and the grant pattern is not systematically re-applied, those objects become unavailable to consumer accounts. This directly affects object availability in the share. Option A is incorrect because DATA_RETENTION_TIME parameter affects how long imported data is retained in the consumer account, not the availability of objects in the share itself. Option B is incorrect because GRANT IMPORTED PRIVILEGES command manages privileges on already imported objects but doesn't affect the fundamental availability of objects in the share. Option D is incorrect because private data exchanges are a secure method of sharing data and don't inherently cause object unavailability. The community discussion strongly supports C with 100% consensus and detailed reasoning explaining why the other options don't cause object unavailability.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What causes shared objects in a data share to become inaccessible for a consumer account?
A
The DATA_RETENTION_IT parameter in the consumer account is set to 0.
B
The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.
C
The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
D
The consumer account acquires the data share through a private data exchange.
No comments yet.