nerdexam
Snowflake

COF-C02 · Question #160

By default, which Snowflake role is required to create a share?

The correct answer is D. ACCOUNTADMIN. Creating a data share is an account-level administrative operation in Snowflake. By default, only the ACCOUNTADMIN role has the privileges necessary to create and manage shares. ORGADMIN manages cross-account organization settings, SECURITYADMIN manages security objects like…

Data Protection and Data Sharing

Question

By default, which Snowflake role is required to create a share?

Options

  • AORGADMIN
  • BSECURITYADMIN
  • CSHAREADMIN
  • DACCOUNTADMIN

How the community answered

(29 responses)
  • A
    3% (1)
  • C
    7% (2)
  • D
    90% (26)

Explanation

Creating a data share is an account-level administrative operation in Snowflake. By default, only the ACCOUNTADMIN role has the privileges necessary to create and manage shares. ORGADMIN manages cross-account organization settings, SECURITYADMIN manages security objects like roles and users, and SHAREADMIN does not exist as a built-in Snowflake role. While other roles can be granted share management privileges, ACCOUNTADMIN is the default requirement.

Topics

#Snowflake Roles#Data Sharing#ACCOUNTADMIN#Permissions

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice