SnowPro Associate: Platform Question 353
Single answer● Snowflake MarketplaceA data engineering team wants to enrich internal sales data with a third-party demographic dataset available through Snowflake Marketplace. The team wants the fastest way to start querying the provider's data in Snowflake without building ingestion pipelines or copying files into their own storage. Which action should the team take?
- A
Install SnowSQL and use it to export the Marketplace dataset into local files before loading it into Snowflake tables
- B
Subscribe to the listing in Snowflake Marketplace so the shared database becomes available in their account for querying
- C
Create an external stage that points to the provider's cloud storage bucket and run COPY INTO commands into internal tables
- D
Request the provider to send daily CSV files through a cloud storage integration because Marketplace listings cannot be queried directly
Show answer and explanation
Correct answer: B
Explanation
Snowflake Marketplace enables providers to publish data products that consumers can discover and subscribe to directly within Snowflake. For many listings, the consumer gains access to the shared data as a database in their own account, allowing immediate querying without ETL pipelines, file transfers, or direct access to the provider's object storage. This is a key Snowflake value proposition: secure data sharing with reduced data movement. For SnowPro Associate-level knowledge, candidates should recognize that Marketplace consumption is based on subscribing to listings and querying shared data, rather than exporting, staging, or copying files manually. See Snowflake documentation on Snowflake Marketplace and Secure Data Sharing for the underlying model and best practices.
- A. Incorrect.
Incorrect. SnowSQL is a command-line client for interacting with Snowflake, but exporting data to local files and reloading it is not the intended or fastest way to consume Marketplace data. Marketplace is designed to let consumers access provider data directly through secure sharing-based mechanisms, avoiding manual extraction and reload steps.
- B. Correct.
Correct. In Snowflake Marketplace, consumers subscribe to a listing, and the data is made available in their Snowflake account as a shared database. This allows the team to query the provider's data directly in place without building ingestion pipelines, moving files, or maintaining ongoing loads.
- C. Incorrect.
Incorrect. Creating an external stage to the provider's cloud storage is not how Snowflake Marketplace consumption normally works. Marketplace listings are consumed through Snowflake's sharing capabilities, not by directly accessing the provider's cloud storage location with COPY INTO. This option reflects a common misconception that Marketplace is just a catalog of files rather than a managed data-sharing mechanism.
- D. Incorrect.
Incorrect. One of the main benefits of Snowflake Marketplace is that listings can be queried directly after subscription, without requiring the provider to deliver raw files on a schedule. Asking for daily CSV delivery adds operational overhead and defeats the purpose of using Marketplace for direct data access.