IMPORTED PRIVILEGES is the right answer. https://docs.snowflake.com/en/user-guide/security-access-control-privileges#:~:text=Usage-,IMPORTED%20PRIVILEGES,-Enables%20roles%20other
The IMPORT SHARE privilege allows a user to import a data share into their account, including data shared through the Snowflake Marketplace.
This privilege enables users to access and use data shared by other Snowflake users or providers through the Marketplace.
C
There are several ways of sharing data on Snowflake, such as:
- Direct share
- Listings (Snowflake Marketplace)
- Data exchange
The question is asking about Snowflake Marketplace, where you can have listings
The question is NOT asking about data shares or data exchanges.
https://other-docs.snowflake.com/en/collaboration/consumer-becoming#set-up-required-privileges
Get a listing for your account, then grant the IMPORTED PRIVILEGES privilege on the database created from the listing to a role on your account. This lets you access the data in the listing without having access to get any listing on the Snowflake Marketplace or privately.
The answer should be C. IMPORT SHARE privileges to a role on your account allows you get access to listings and therefore, receive and request data from Snowflake Marketplace. Once you do get listing for your account, then you would need IMPORTED PRIVILEGES to access it.
To support delegating these tasks to other users, the IMPORTED PRIVILEGES privilege can be granted on a Data Exchange to other roles.
IMPORT SHARE & CREATE DATABASE
the question is not asking about data exchange. It is asking about Snowflake Marketplace and listing. Please see the difference here: https://docs.snowflake.com/en/user-guide/data-sharing-intro
C.
When logging in to the Data Exchange as a consumer:
All roles can browse data listings.
All roles with the ACCOUNTADMIN role can request and get data.
All roles with the IMPORT SHARE and CREATE DATABASE privileges can get and request data.
https://docs.snowflake.com/en/user-guide/data-exchange-accessing
C - IMPORT SHARE
You must use the ACCOUNTADMIN role (or a role granted the IMPORT SHARE global privilege) to perform these tasks. For more details about the IMPORT SHARE privilege, see Enabling non-ACCOUNTADMIN roles to perform data sharing tasks.
Answer C as per this documentation https://other-docs.snowflake.com/en/collaboration/consumer-becoming#:~:text=To%20access%20a%20listing%2C%20you%20must%20use%20the%20ACCOUNTADMIN%20role%20or%20another%20role%20with%20the%20CREATE%20DATABASE%20and%20IMPORT%20SHARE%20privileges
A
https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges#label-create-data-exchange-listing-on-account
If the global CREATE DATA EXCHANGE LISTING privilege is granted to a role, any user with the role can create a listing or provider profile. As the creator and, therefore owner of the listing, the role can be used to perform all tasks on the listing, including:
Create listings
Modify listings properties
View listings
View incoming listing access requests
Reject listing requests
Submit listings for approval/publishing listings
Create and view provider profiles
To access a listing, you must use the ACCOUNTADMIN role or another role with the CREATE DATABASE and IMPORT SHARE privileges.
https://other-docs.snowflake.com/en/collaboration/consumer-becoming.html#set-up-required-privileges
IMPORT SHARE - Applies to data consumers. Grants the ability to view shares shared with your account. Also grants the ability to create databases from the shares.
IMPORTED PRIVILEGES - manage a Snowflake Marketplace or Data Exchange
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Renvis
Highly Voted 1 year, 8 months agoLematthew31
Most Recent 6 months ago0e504b5
8 months, 3 weeks ago[Removed]
12 months ago0e504b5
8 months, 3 weeks agokayuhanbiduk
1 year agokayuhanbiduk
1 year agokayuhanbiduk
1 year agodpexam2023
1 year, 1 month agoZaaju
1 year, 2 months agoGulpa
1 year, 3 months agomingzeng0226
1 year, 4 months agoMultiCloudIronMan
1 year, 6 months agookurok
1 year, 7 months agojtm22
1 year, 7 months agoMakabaka
1 year, 7 months agoEmiB
1 year, 7 months ago