Chapter 5 of 6 · Snowflake ADA-C02

Data Sharing and Snowflake Marketplace

Shares, reader accounts, clean rooms, listings, usage monitoring and Native Apps.

  • 10topics
  • 49 minfast track
  • 2diagrams and exhibits
  • 7%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Implementing Data Sharing, Sharing Models and EditionsImplement and manage Secure Data Sharing, choose between one to one, one to many, private and public models, and share across…Diagram5 min
  2. 2Cross-Region and Cross-Cloud Sharing, Replication and Auto-FulfillmentShare across regions and clouds with replication or Cross-Cloud Auto-Fulfillment, including refresh options, costs, limits and…Diagram6 min
  3. 3Programmatic Sharing, Shareable Objects, Context Functions and ProvidersConfigure sharing with SQL, know which object types can be shared, use context functions such as CURRENT_ACCOUNT safely, and…5 min
  4. 4Outbound Shares, Secure Views and Secure UDFsCreate and maintain outbound shares, choose the right object type to share, know when to use views and secure views, and share…5 min
  5. 5Reader Accounts - Create, Users, Resource Monitors and ObjectsCreate and maintain Snowflake reader accounts, set up users and roles, add resource monitors, see what can be created, and decide…5 min
  6. 6Inbound Data Shares and Installing Snowflake Data Clean RoomsImport and maintain inbound data shares, then configure Snowflake Data Clean Rooms by installing the clean room native app and…5 min
  7. 7Clean Rooms - Bringing Users In and Managing CollaboratorsBring users into a Snowflake Data Clean Room, define collaborators and their roles in a collaboration, and manage joins, edits…4 min
  8. 8Snowflake Marketplace - Access, Internal versus Public Listings, Becoming a ProviderImplement the Snowflake Marketplace, access public and internal listings, choose between internal and public data listings, and…4 min
  9. 9Provider Profiles, Creating Listings and Managing Listing RequestsCreate and edit provider profiles, build and submit a listing in Provider Studio, modify published listings, and manage listing…5 min
  10. 10Monitoring Data Sharing Usage and Managing Native AppsMonitor data sharing usage with the DATA_SHARING_USAGE views and Provider Studio, and manage Snowflake Native Apps, versions…5 min

About this chapter

What this chapter covers

Data Sharing and Snowflake Marketplace is the chapter on how an administrator gives data to other parties, receives data from them, and runs the programs around that: reader accounts, clean rooms, listings and Native Apps. For the SnowPro Advanced: Administrator ADA-C02 exam it tests which sharing method fits a situation and which privilege, command or setting makes it work.

Questions are scenarios that start with "An administrator needs to ...". They are single answer, multiple select or interactive, and the answer usually hinges on one fact: same region or not, secure view or plain view, who pays, or which role holds the privilege.

How the topics fit together

Sharing is built in stages. Each stage adds reach or control.

Shareprovider objectsreach other regionsReplication and auto fulfillmentcross cloudprotectSecure views and UDFshide logicextendReader accountsno account neededcollaborateClean roomsjoint analysispublishMarketplacelistings and apps
  • Sharing models decide the audience: one to one, one to many, private or public.
  • Cross region and cross cloud sharing always needs a copy in the consumer region, by replication or by Cross-Cloud Auto-Fulfillment.
  • Secure objects protect what a consumer can see: secure views, secure UDFs and context functions such as CURRENT_ACCOUNT().
  • Reader accounts serve consumers without Snowflake; the provider pays their compute.
  • Inbound shares and clean rooms cover the consumer side and joint analysis without exposing raw data.
  • Marketplace covers provider profiles, listings, requests, usage monitoring and Native Apps.
Exam tip

Three facts decide most questions: direct shares stay within one region and cloud; sensitive logic goes behind secure views; and the provider pays for reader accounts.

How to use these pages

Each topic page has the same shape, so you can skim for what you need.

  • What it is: the idea in plain words.
  • How it works: the mechanism, with diagrams, SQL and comparison tables.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

Read the pages in order the first time. The later pages reuse the shares, secure views and listings from the earlier ones.

Ready for more practice?

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.