SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 95

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?

Use Secure Data Sharing with an S3 bucket as a destination.

Publish PRODUCT_CATEGORY and PRODUCT_DETAILS data sets on the Snowflake Marketplace.

Create a database user for the partner and give them access to the required data sets.

Create a reader account for the partner and share the data sets as secure views.

Correct Answer: D

Creating a reader account for the partner and sharing the data sets as secure views ensures both costs and security are managed effectively. This approach allows controlled access to the data without the partner needing to be a Snowflake customer, ensuring the data remains secure and only accessible to the intended recipient.

Discussion

BuckeyeRCBOption: D

Data has to be governed and thus secure view based on the two tables is the right option here.