Enable data collaboration and protection — SnowPro® Core Certification

Official references for this objective

• Snowflake — Create and configure shares | Snowflake Documentation

  A new object created or recreated in a database granted to a share is not automatically available to consumers.

• Snowflake — Understanding row access policies | Snowflake Documentation

  As a workaround, use the CURRENT_ACCOUNT function in the policy conditions. Alternatively, as a provider, write the policy conditions to call the IS_DATABASE_ROLE_IN_SESSION function and

• Snowflake — Understanding Column-level Security | Snowflake Documentation

  Masking policies can include conditions and functions to transform the data at query runtime when those conditions are met.

• Snowflake — Overview of Provider and Consumer Clean Rooms | Snowflake Documentation

  Data imported into a clean room cannot be queried or viewed directly by either party — either the provider or the consumer — but can

• Snowflake — Projection policies | Snowflake Documentation

  A column can only have one projection policy assigned to it at any given time.

• Snowflake — About Secure Data Sharing | Snowflake Documentation

  Shared data does not take up any storage in a consumer account and therefore does not contribute to the consumer’s monthly data storage charges. The

• Snowflake — About listings | Snowflake Documentation

  Providers can set the availability period for limited trial listings from 1 to 90 days.

• Snowflake — Differential privacy in Snowflake Data Clean Rooms | Snowflake Documentation

  providers can set privacy settings at the template level; consumers cannot enable or modify differential privacy settings

• Snowflake — Tag-based masking policies | Snowflake Documentation

  Use the FORCE keyword to replace the policy in a single statement.