SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 69

Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.

If a user in the provider account with role authority to CREATE or ALTER SHARE adds an Enterprise account as a consumer, it can import the share.

If a user in the provider account with a share owning role sets SHARE_RESTRICTIONS to False when adding an Enterprise consumer account, it can import the share.

If a user in the provider account with a share owning role which also has OVERRIDE SHARE RESTRICTIONS privilege SHARE_RESTRICTIONS set to False when adding an Enterprise consumer account, it can import the share.

Correct Answer: C

A Business Critical Snowflake account can share data with an Enterprise edition consumer account if a user in the provider account with the appropriate share-owning role sets SHARE_RESTRICTIONS to False when adding the Enterprise consumer account. This allows the data sharing to occur despite the different account editions.

Discussion

swe12Option: D

D is right https://docs.snowflake.com/en/user-guide/override_share_restrictions