SnowPro Advanced: Architect — Question 83
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?
Answer options
- 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.
Correct answer: D
Explanation
The correct answer is D because creating a reader account allows the partner to access the data securely while controlling permissions through secure views. Option A is incorrect as Secure Data Sharing does not support S3 as a destination. Option B is not ideal since publishing on the Marketplace may not provide the required level of security and control. Option C would expose more data management risks by creating a database user.