Snowflake Exam ADA-C01 Topic 6 Question 27 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 27
Topic #: 6

[All ADA-C01 Questions]

What are characteristics of data replication in Snowflake? (Select THREE).

AThe ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

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 secondary database resides.

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 of accounts if all accounts are within the same organization.

Show Suggested Answer

Suggested Answer: A, E, F

* 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 replicated1.

* Option B is incorrect because users must be granted REPLICATIONGRANTER privileges in order to enable replication1.

* Option C is incorrect because to start replication, the ALTER DATABASE ... REFRESH command must be run on the primary database, not the secondary database1.

* Option D is incorrect because replication can occur across different cloud providers, as well as across regions2.

* 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 altered1.

* 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 organization1.

by Stefany at Sep 12, 2024, 07:57 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Keva

16 days ago

Hmm, I'm not sure about C. Isn't the REFRESH command used to update the replicated data, not start the replication process? But the other three choices make sense.

upvoted 0 times

...

Gearldine

20 days ago

D is definitely not correct. Snowflake replication can cross cloud provider boundaries, that's one of the key features. The rest seem spot on though.

upvoted 0 times

Lemuel

5 days ago

A) The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

upvoted 0 times

...

1 months ago

I think characteristics of data replication in Snowflake include granting REPLICATIONADMIN privileges.

upvoted 0 times

...