SnowPro Advanced: Administrator — Question 9

What are characteristics of data replication in Snowflake? (Choose three.)

Answer options

• A. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
• B. Users must be granted REPLICATIONADMIN privileges in order to enable replication.
• C. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
• D. Replication can only occur within the same cloud provider.
• E. Databases created from shares can be replicated.
• F. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

Correct answer: A, C, E

Explanation

Option A is correct because the command must indeed be run from the primary account to enable replication. Option C is also correct as the ALTER DATABASE ... REFRESH command is necessary to start the replication process on the secondary database's account. Option E is right since databases created from shares can be replicated, while options B, D, and F are not accurate in the context of Snowflake's data replication features.