A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?
A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?
To allow data sharing from a Business Critical Snowflake edition to a Standard edition, the `share_restriction` parameter on the shared object must be set to false. By default, Snowflake does not permit sharing data from a Business Critical to a non-Business Critical account unless this parameter is configured accordingly, ensuring proper access controls and compliance measures are maintained.
https://docs.snowflake.com/en/user-guide/override_share_restrictions For me it looks as D: -- grant the privilege to the SYSADMIN role use role accountadmin; grant override share restrictions on account to role sysadmin; -- SYSADMIN can now add a consumer account to a share with the SHARE_RESTRICTIONS parameter set to false use role sysadmin; alter share <share_name> add accounts = <consumer_account_name> SHARE_RESTRICTIONS=false;
It is D. https://docs.snowflake.com/en/user-guide/override_share_restrictions -> By default, Snowflake does not allow sharing data from a Business Critical to a non-Business Critical account.
It is B. Sharing is SUPPORTED from business critical to any, but not ENABLED.
B. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition. Snowflake allows data sharing between different editions of accounts, including from higher editions (like Business Critical) to lower editions (like Standard). This means that the healthcare company can share data with the medical institute without needing to change the institute’s Snowflake edition or contact Snowflake for assistance.
Not D. SHARE_RESTRICTIONS is an account parameter, not an object
Answer is D and is validated