Data marketplace and listings in Snowflake - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ service_behavior

intermediate

Understanding Data Marketplace Listing Visibility

You have published a dataset to the Snowflake Data Marketplace. Which factor determines if your listing is visible to other Snowflake accounts?

A The dataset must be shared with the PUBLIC role in your account.

B The dataset must be stored in an internal stage within your account.

C The listing must be approved and published by Snowflake after submission.

D The listing is automatically visible once the share is created.

💡 Hint

Think about the approval process for marketplace listings.

Listings on the Snowflake Data Marketplace require approval and publication by Snowflake before they become visible to other accounts. Simply creating a share or storing data internally does not make the listing public.

❓ Architecture

intermediate

Best Architecture for Secure Data Sharing via Marketplace

You want to share sensitive data via Snowflake Data Marketplace but ensure only authorized consumers can access it. Which architecture best supports this?

A Create a share and restrict access using reader accounts with specific grants.

B Publish the dataset as a listing and require consumers to request access via Snowflake's approval process.

C Create a share with the dataset and grant access to the PUBLIC role.

D Upload data to an external stage and share the stage URL publicly.

💡 Hint

Consider how to control access tightly while using marketplace shares.

Using reader accounts with specific grants allows you to control who can access the shared data securely. Granting access to PUBLIC or sharing external stage URLs publicly exposes data without control.

❓ Configuration

advanced

Configuring a Data Marketplace Listing with Custom Metadata

Which Snowflake SQL command correctly adds custom metadata tags to a data marketplace listing named my_listing in the MARKETPLACE_SCHEMA schema?

A ALTER LISTING MARKETPLACE_SCHEMA.my_listing SET TAGS = ('industry=finance', 'region=us');

B ALTER LISTING MARKETPLACE_SCHEMA.my_listing SET TAGS = ('industry:finance', 'region:us');

C ALTER LISTING MARKETPLACE_SCHEMA.my_listing SET TAG = ('industry=finance', 'region=us');

D ALTER LISTING MARKETPLACE_SCHEMA.my_listing SET TAGS = ('industry:finance', 'region=us');

💡 Hint

Check the syntax for setting tags in Snowflake listings.

The correct syntax uses SET TAGS with key:value pairs separated by colons inside single quotes. Using equal signs or SET TAG is invalid syntax.

❓ security

advanced

Identifying Security Risks in Marketplace Data Sharing

Which of the following scenarios poses the greatest security risk when sharing data via Snowflake Data Marketplace?

A Sharing data with reader accounts that have limited access and expiration policies.

B Requiring consumers to authenticate with their own Snowflake accounts.

C Using secure views to expose only specific columns in the shared dataset.

D Publishing a listing with sensitive data without masking or encryption.

💡 Hint

Consider what happens if sensitive data is exposed directly.

Publishing sensitive data without masking or encryption exposes it to all consumers, which is a major security risk. Using reader accounts, secure views, and authentication helps protect data.

✅ Best Practice

expert

Optimizing Data Marketplace Listings for Performance and Cost

You manage multiple large datasets listed on Snowflake Data Marketplace. To optimize performance and reduce costs for consumers, which approach is best?

A Create curated views with pre-filtered and aggregated data for listings.

B Use reader accounts with unlimited compute warehouses for consumers.

C Store datasets in external stages and share stage URLs directly.

D Publish full raw datasets and let consumers filter data after download.

💡 Hint

Think about reducing data volume and compute for consumers.

Curated views with pre-filtered and aggregated data reduce the amount of data scanned and transferred, improving performance and lowering costs. Sharing raw data or external stages can increase costs and complexity.