QuestionQ50

Implement disaster recovery, perform backups, and replicate data

Which are characteristics of data replication in Snowflake?

Choose three
Explanation

A primary database is enabled for replication from its source account by using ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS. The initial and subsequent synchronization of a secondary database is performed in the target account with ALTER DATABASE ... REFRESH. An account can designate any number of databases as primary databases, and each primary database can be replicated to any number of accounts within the same organization. Database replication also supports different regions and cloud platforms; databases created from shares cannot be replicated.

Learn more

Community Discussion

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