Answer: IMPORT SHARE

The correct answer is C (IMPORT SHARE) based on Snowflake documentation and community consensus. IMPORT SHARE is the global privilege required for users to access and consume data from Snowflake Marketplace listings. This privilege allows users to view shares shared with their account and create databases from those shares, which is essential for receiving data from Marketplace listings. While some community members suggested D (IMPORTED PRIVILEGES), this is actually used for managing Marketplace/Data Exchange objects after access is granted, not for the initial data consumption. Option A (CREATE DATA EXCHANGE LISTING) is for providers creating listings, not consumers. Option B (CREATE SHARE) is for data providers sharing data, not consumers receiving data. The documentation clearly states that to access a listing, users need either ACCOUNTADMIN role or a role with CREATE DATABASE and IMPORT SHARE privileges.

Author: LeetQuiz Editorial Team