Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 520

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

    Correct Answer: C

    Objects in a data share become unavailable to a consumer account if those objects are being deleted and the grant pattern is not re-applied systematically. This results in the consumer losing access to the shared objects, as the permissions are no longer in effect after deletion.

Discussion
sjnddsOption: C

A. The DATA_RETENTION_TIME parameter in the consumer account determines how long data that is imported from a data share is retained in the account. If this parameter is set to 0, the data is immediately deleted after import. This parameter setting does not affect the availability of objects in the data share. B. The GRANT IMPORTED PRIVILEGES command is used to grant privileges on objects that are imported from a data share to a consumer account. Running this command every 24 hours does not affect the availability of objects in the data share. D. Private data exchange is a feature that allows two or more Snowflake accounts to exchange data privately, without going through the public internet. Acquiring a data share through a private data exchange does not affect the availability of objects in the data share.

_yyuktaOption: C

C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

MultiCloudIronManOption: C

Correct