SnowPro Core Certification — Question 477

What causes objects in a data share to become unavailable to a consumer account?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because if the objects in the data share are deleted and the grant pattern is not reapplied, they become unavailable. Option A is incorrect as setting DATA_RETENTION_IT to 0 does not directly cause unavailability, rather it affects data retention. Option B is not correct since the GRANT INPORTED PRIVILEGES command does not lead to unavailability if executed regularly. Option D is irrelevant because acquiring a data share through a private exchange does not inherently make the objects unavailable.