Snowflake separates the privileges required to discover listings, request access, create imported databases, and query data received through secure sharing.
Option C is correct because ACCOUNTADMIN has the necessary administrative authority to request and receive data through a Data Exchange.
Option D is correct because Snowflake supports delegating these capabilities to custom roles that hold the global IMPORT SHARE and CREATE DATABASE privileges.
IMPORT SHARE permits a role to access incoming shares made available to the consumer account. CREATE DATABASE permits creation of the database object used to expose the shared data.
For example:
GRANT IMPORT SHARE ON ACCOUNT
TO ROLE DATA_CONSUMER;
GRANT CREATE DATABASE ON ACCOUNT
TO ROLE DATA_CONSUMER;
```
Option A is incorrect because SYSADMIN does not automatically receive IMPORT SHARE merely through its standard system-role membership.
Option B is similarly incorrect because SECURITYADMIN's administrative authority does not automatically confer the privileges required to consume shares.
Option E references inappropriate privilege terminology and does not describe a valid combination for receiving Data Exchange data.
Once the shared database is created, access can be delegated through the applicable imported-database privileges.
Snowflake explicitly documents ACCOUNTADMIN and roles holding IMPORT SHARE together with CREATE DATABASE as the supported consumer-access models.
Official Snowflake references: Access a Data Exchange; Grant Privileges to Other Roles; Enable Non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks.
Submit