ADA-C01 Question 437
Single answerEvaluate different sharing models (one to one, one to many, private, public)A data provider uses Snowflake to distribute curated sales data to external companies. One strategic partner requires a dedicated share containing custom secure views and a unique set of objects that no other consumer can access. At the same time, the provider wants to distribute a standardized product catalog to hundreds of customers with minimal administrative overhead and broad discoverability. Which combination of sharing models best meets these requirements?
- A
Use a private one-to-one share for the strategic partner, and publish the product catalog as a public listing for the broader customer base.
- B
Use a public listing for the strategic partner, and create separate private one-to-one shares for each customer needing the product catalog.
- C
Use a private one-to-many share for the strategic partner, and a private one-to-one share for the product catalog customers.
- D
Use reader accounts for the strategic partner, and avoid listings because shares cannot be reused across multiple consumers.
Show answer and explanation
Correct answer: A
Explanation
This scenario requires distinguishing between targeted sharing and scaled distribution. For a single partner needing a dedicated dataset with custom secure views, a private one-to-one share is the most appropriate model because it provides precise control over which consumer receives which objects. For a standardized dataset intended for many customers, a listing-based distribution model is preferred, especially when the provider wants reduced operational effort and better discoverability. In Snowflake, direct shares are well suited to controlled business-to-business sharing, while listings support broader one-to-many distribution patterns. Public listings are discoverable to a wide audience, whereas private listings are restricted to selected consumers; the key exam concept is evaluating whether the use case calls for direct share granularity or scalable listing-based distribution. This aligns with Snowflake best practices for Secure Data Sharing and data products, including the distinction between direct shares, listings, and when to use one-to-one versus one-to-many access patterns.
- A. Correct.
Correct. A private one-to-one share is appropriate when a provider needs to grant a specific consumer access to a unique set of objects, such as custom secure views or tailored datasets. For the standardized product catalog intended for many customers with low operational overhead and discoverability, a public listing in the Snowflake Marketplace/privately exchanged listing model is the best fit because it supports broad distribution and easier consumer access at scale.
- B. Incorrect.
Incorrect. A public listing is not appropriate for a single strategic partner requiring a dedicated, restricted dataset, because the requirement is for a unique set of objects available only to that partner. Creating separate private one-to-one shares for hundreds of customers would work technically, but it does not meet the goal of minimizing administrative overhead compared to using a listing for standardized data distribution.
- C. Incorrect.
Incorrect. A private one-to-many share gives multiple consumers access to the same shared objects, so it does not satisfy the requirement that only one strategic partner can access a unique set of objects. Likewise, using private one-to-one shares for the product catalog customers increases ongoing administration and does not align with the need for scalable distribution to hundreds of customers.
- D. Incorrect.
Incorrect. Reader accounts can be useful when consumers do not have their own Snowflake accounts, but the scenario is specifically about choosing sharing models, not provisioning compute-backed consumer access. The statement that shares cannot be reused across multiple consumers is also a misconception: Snowflake supports one-to-many sharing, and listings are specifically designed for scaled distribution.