Answer: CREATE SHARE, CREATE DATABASE

The question asks about privileges needed for a role to manage access to shared objects using database roles in a direct share. In Snowflake, when using direct shares with database roles, the role requires the CREATE SHARE privilege to create and manage the share itself, and the CREATE DATABASE privilege to create the database that will contain the shared objects and manage the database roles. The community discussion shows 100% consensus on answers D and E, confirming these are the correct privileges. Other options are incorrect: CREATE PIPE is for data loading, CREATE STREAM is for change data capture, and CREATE TASK is for scheduling automated workflows - none of these are relevant to managing access control for shared objects.

Author: LeetQuiz Editorial Team