SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ74

Secure Data Sharing and Consumption

A company must share its product catalog data with one of its partners. The product catalog is stored in two database tables: PRODUCT_CATEGORY and PRODUCT_DETAILS. The two tables can be joined using the PRODUCT_ID column. Access to the data must be governed, and only the partner must be able to access the records.

The partner is not a Snowflake customer and uses Amazon S3 for cloud storage.

Which design is the MOST cost-effective and secure while using the required Snowflake features?

Explanation

Snowflake reader accounts enable a provider to share data with consumers that are not Snowflake customers, while the provider retains ownership and management of the account. Sharing secure views lets the provider expose the required joined and governed result set without granting access to the underlying tables; Snowflake recommends secure views for shared sensitive data. Secure Data Sharing does not use an Amazon S3 bucket as its destination, and Marketplace publication would not restrict the data to only this partner.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!