SnowPro Advanced: Architect — Question 78

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

Answer options

• A. A Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any consumer accounts must also be Business Critical.
• B. 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.
• C. 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.
• D. 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: D

Explanation

The correct answer is D because it specifies that a user must have the OVERRIDE SHARE RESTRICTIONS privilege to allow sharing with an Enterprise account. Option A is incorrect as it incorrectly states that a Business Critical account cannot share with Enterprise accounts at all. Options B and C fail to mention the necessary privilege needed to override the share restrictions.