QuestionQ55

Implement disaster recovery, perform backups, and replicate data

A Snowflake organization, MYORG, contains two Snowflake accounts:

Question Image

ACCOUNT1 has a database named PROD_DB and has the ORGADMIN role enabled. Management wants PROD_DB replicated to ACCOUNT2.

Are any configuration steps required in ACCOUNT1 before database replication can be configured and started in ACCOUNT2?

Explanation

Snowflake requires an ORGADMIN to run SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER to set ENABLE_ACCOUNT_DATABASE_REPLICATION to true for each account participating in replication, and then an ACCOUNTADMIN in the primary account must promote the database with ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS before a secondary database can be created in the target account. The IGNORE EDITION CHECK clause is only needed when the primary database resides in a Business Critical (or higher) edition account replicating to a lower-edition account; since ACCOUNT1 is Enterprise edition, replicating to the Standard edition ACCOUNT2 does not require that clause, so configuration steps (enabling the parameter for both accounts and promoting the database) are indeed required in ACCOUNT1 without IGNORE EDITION CHECK.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!