Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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).

Show Suggested Answer Hide 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.


Contribute your Thoughts:

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
...
...
Francesco
27 days ago
A, B, and E. Sounds like the classic Snowflake replication setup to me. Though I'm a bit curious about the unlimited primary databases claim - must be a typo or a joke, right?
upvoted 0 times
Minna
8 days ago
E) Databases created from shares can be replicated.
upvoted 0 times
...
German
11 days ago
Yes, you need to issue the ALTER DATABASE command from the primary account to enable replication.
upvoted 0 times
...
Margarett
12 days ago
B) Users must be granted REPLICATIONADMIN privileges in order to enable replication.
upvoted 0 times
...
Arminda
13 days ago
A, B, and E are correct. The unlimited primary databases claim is actually true.
upvoted 0 times
...
Maryann
16 days ago
A) The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
upvoted 0 times
...
...
Catalina
1 months ago
Yes, and databases created from shares can also be replicated in Snowflake.
upvoted 0 times
...
Kent
1 months ago
I believe starting replication requires running the ALTER DATABASE ... REFRESH command on the secondary account.
upvoted 0 times
...
Catalina
1 months ago
I think characteristics of data replication in Snowflake include granting REPLICATIONADMIN privileges.
upvoted 0 times
...

Save Cancel