ADA-C01 Question #17: Real Exam Question with Answer & Explanation

The correct answer is A. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued E. Databases created from shares can be replicated. F. Users can have unlimited primary databases and they can be replicated to an unlimited number. Option A is correct because the ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account that owns the database to be replicated. Option E is correct because databases created from shares can be replicated, as long as the share is active a

Question

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

Options

AThe ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued
BUsers must be granted REPLICATIONADMIN privileges in order to enable replication.
CTo start replication run the ALTER DATABASE ... REFRESH command on the account where the
DReplication can only occur within the same cloud provider.
EDatabases created from shares can be replicated.
FUsers can have unlimited primary databases and they can be replicated to an unlimited number

Explanation

Option A is correct because the ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account that owns the database to be replicated. Option E is correct because databases created from shares can be replicated, as long as the share is active and the database is not dropped or altered. Option F is correct because 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.

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice