nerdexam
Snowflake

COF-C02 · Question #511

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

The correct answer is A. ACCOUNTADMIN. The ENABLE_ACCOUNT_DATABASE_REPLICATION parameter is a critical setting in Snowflake that allows or restricts the replication of databases across Snowflake accounts. Given the significant impact of this parameter on data management and security, only the ACCOUNTADMIN role has…

Account Access and Security

Question

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

Options

  • AACCOUNTADMIN
  • BSECURITYADMIN
  • CSYSADMIN
  • DORGADMIN

How the community answered

(46 responses)
  • A
    93% (43)
  • B
    2% (1)
  • D
    4% (2)

Explanation

The ENABLE_ACCOUNT_DATABASE_REPLICATION parameter is a critical setting in Snowflake that allows or restricts the replication of databases across Snowflake accounts. Given the significant impact of this parameter on data management and security, only the ACCOUNTADMIN role has the minimum required privileges to set or modify it. This ensures that only users with the highest level of access and responsibility within the Snowflake environment can control database replication settings, maintaining strict governance and security standards.

Topics

#Account Roles#Account Parameters#Database Replication

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice