SnowPro Core Certification — Question 1206

When using a direct share, what privileges does a role need to control access to the objects that are in a share that is using database roles? (Choose two.)

Answer options

• A. CREATE PIPE
• B. CREATE STREAM
• C. CREATE TASK
• D. CREATE SHARE
• E. CREATE DATABASE

Correct answer: D, E

Explanation

The correct answers are D and E because a role must have the CREATE SHARE privilege to create and manage shares, as well as the CREATE DATABASE privilege to control access to the underlying database objects. The other options, while related to other functionalities in Snowflake, do not provide the necessary privileges for managing share access.