Skip to Content

Snowflake SnowPro Core: Causes objects in data share to become unavailable to consumer account

Question

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

A. The DATA_RETENTION_TIME_IN_DAYS 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.

Answer

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

Explanation

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

A data share is a secure and easy way to share live data across different Snowflake accounts. A data share consists of one or more database objects, such as schemas, tables, views, or secure views, that are granted to a consumer account. A consumer account can access the shared data through a share database that is automatically created when the data share is accepted.

However, there are some scenarios where the objects in a data share may become unavailable to a consumer account. One of them is when the objects in the data share are being deleted and the grant pattern is not re-applied systematically. A grant pattern is a set of SQL statements that grant privileges on the shared objects to the consumer account. If the provider account deletes and recreates the shared objects, the grant pattern needs to be re-applied to restore the privileges on the new objects. Otherwise, the consumer account will lose access to the shared data.

The other options are incorrect because:

  • A. The DATA_RETENTION_TIME_IN_DAYS parameter in the consumer account is set to 0. This is false because this parameter does not affect the availability of the objects in a data share. This parameter controls how long Snowflake retains historical data (also known as time travel) for tables in the consumer account. It does not affect the access to the live data in the share database.
  • B. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours. This is false because this command does not cause the objects in a data share to become unavailable. This command allows the consumer account to import privileges from another account that has access to the same data share. It does not revoke or modify any existing privileges on the shared objects.
  • D. The consumer account acquires the data share through a private data exchange. This is false because this does not affect the availability of the objects in a data share. A private data exchange is a platform that allows Snowflake accounts to discover and acquire data shares from other accounts within a trusted network. It does not change how the shared data is accessed or granted.

Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.