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

Miesha

7 months ago

Wait, so Snowflake replication is like a game of musical chairs, where the databases have to keep moving from one account to another to avoid getting left out in the cold? Sounds like a real winter wonderland!

upvoted 0 times

Cathrine

7 months ago

E) Databases created from shares can be replicated.

upvoted 0 times

...

Mozell

7 months ago

B) Users must be granted REPLICATIONADMIN privileges in order to enable replication.

upvoted 0 times

...

Cruz

7 months ago

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

upvoted 0 times

...

Laquita

8 months ago

F is definitely a trap answer. I've never heard of unlimited primary databases in Snowflake - that sounds like a snowball's chance in hell!

upvoted 0 times

Alica

7 months ago

C) To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

upvoted 0 times

...

Tien

7 months ago

B) Users must be granted REPLICATIONADMIN privileges in order to enable replication.

upvoted 0 times

...

Hui

7 months ago

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

upvoted 0 times

...

Keva

8 months 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

8 months 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

Izetta

7 months ago

E) Databases created from shares can be replicated.

upvoted 0 times

...

Natalie

7 months ago

C) To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

upvoted 0 times

...

Merissa

7 months ago

B) Users must be granted REPLICATIONADMIN privileges in order to enable replication.

upvoted 0 times

...

Lemuel

8 months ago

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

upvoted 0 times

...

Francesco

9 months 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