Which role has the ability to create a share from a shared database by default?

The correct answer is A. ACCOUNTADMIN. By default, the ACCOUNTADMIN role in Snowflake has the ability to create a share from a shared database. This role has the highest level of access within a Snowflake account, including the management of all aspects of the account, such as users, roles, warehouses, and…

Data Protection and Data Sharing

Question

Options

AACCOUNTADMIN
BSECURITYADMIN
CSYSADMIN
DORGADMIN

How the community answered

(41 responses)

A
93% (38)
B
2% (1)
D
5% (2)

Explanation

By default, the ACCOUNTADMIN role in Snowflake has the ability to create a share from a shared database. This role has the highest level of access within a Snowflake account, including the management of all aspects of the account, such as users, roles, warehouses, and databases, as well as the creation and management of shares for secure data sharing with other Snowflake

Topics

#Snowflake Roles#Default Privileges#Data Sharing#ACCOUNTADMIN

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice