hiexam
snowflake · SnowPro-Advanced-Architect · Q605 · multiple_choice · topic_1

A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two d…

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.
Explanation
Data has to be governed and thus secure view based on the two tables is the right option here.

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.