Secure data sharing using reader accounts and secure views. Learn how to effectively share data with partners who are not Snowflake customers.
Table of Contents
Question
A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: PRODUCT_CATEGORY, and PRODUCT_DETAILS. Both tables can be joined by the PRODUCT_ID column. Data access should be governed, and only the partner should have access to the records.
The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
Which design will be the MOST cost-effective and secure, while using the required Snowflake features?
A. Use Secure Data Sharing with an S3 bucket as a destination.
B. Publish PRODUCT_CATEGORY and PRODUCT_DETAILS data sets on the Snowflake Marketplace.
C. Create a database user for the partner and give them access to the required data sets.
D. Create a reader account for the partner and share the data sets as secure views.
Answer
D. Create a reader account for the partner and share the data sets as secure views.
Explanation
Secure views allow you to share data without exposing the underlying tables or giving direct access to the data. This ensures that the partner only has access to the records they need. A reader account is a type of Snowflake account that is used specifically for data sharing.
It allows the partner to query the shared data using SQL, but they cannot modify the data or metadata. This is a cost-effective solution because the partner is only charged for the compute resources they use, not for the storage of the shared data.
Snowflake SnowPro Advanced Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Advanced Architect exam and earn Snowflake SnowPro Advanced Architect certification.