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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ADA-C01 Exam - Topic 7 Question 42 Discussion

What are characteristics of data replication in Snowflake? (Select THREE).
A) The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account. and E) Databases created from shares can be replicated. and 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.
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.

Snowflake ADA-C01 Exam - Topic 7 Question 42 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 42
Topic #: 7
[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.


by Kaitlyn at Aug 18, 2025, 03:04 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rana
6 months ago
E is interesting, sharing databases for replication is a cool feature!
upvoted 0 times
...
Annette
6 months ago
B is correct, you need those REPLICATIONADMIN privileges.
upvoted 0 times
...
Casey
7 months ago
I thought replication could happen across different cloud providers?
upvoted 0 times
...
Lemuel
8 months ago
Wait, unlimited databases? That sounds too good to be true!
upvoted 0 times
...
Gearldine
8 months ago
A is definitely true, must come from the primary account.
upvoted 0 times
...
Rickie
8 months ago
I definitely remember that databases created from shares can be replicated, but I’m not confident about the specifics of how that works.
upvoted 0 times
...
Carlota
8 months ago
I practiced a question similar to this, and I feel like replication might be limited to the same cloud provider, but I could be mixing it up with something else.
upvoted 0 times
...
Jacinta
8 months ago
I remember something about needing special privileges for replication, like REPLICATIONADMIN, but I can't recall if that's the only requirement.
upvoted 0 times
...
Ardella
9 months ago
I think the command to enable replication has to be run from the primary account, but I'm not completely sure if it's the ALTER DATABASE command.
upvoted 0 times
...
Meghan
9 months ago
I've got a good handle on data replication in Snowflake. The key things are that you need REPLICATIONADMIN privileges, the ALTER DATABASE commands are used to enable and refresh replication, and replication can only happen within the same cloud provider. I'm feeling pretty confident about this topic.
upvoted 0 times
...
Barbra
9 months ago
Okay, let me think this through. I know replication has to be within the same cloud provider, and that databases created from shares can be replicated. But I'm not sure about the other details like the ALTER DATABASE commands and the privilege requirements. I'll make sure to double-check those.
upvoted 0 times
...
Kassandra
9 months ago
Hmm, I'm a bit unsure about the details here. I know replication is important, but I can't recall all the specific requirements and commands. I'll need to review the Snowflake documentation to make sure I understand this properly.
upvoted 0 times
...
Eloisa
9 months ago
I'm pretty confident about this one. The key things I remember are that replication requires the REPLICATIONADMIN privilege, and that the ALTER DATABASE commands are used to enable and refresh replication.
upvoted 0 times
...
Colton
10 months ago
Yes, that's correct. Users need those privileges to enable replication.
upvoted 0 times
...
Myong
10 months ago
I think characteristics of data replication in Snowflake include granting REPLICATIONADMIN privileges.
upvoted 0 times
...
Valentin
10 months ago
D, that's hilarious! Replication within the same cloud provider? What is this, the stone age? A, B, and E are the way to go. Snowflake's got some cool tricks up its sleeve, but they don't let you get away with just anything.
upvoted 0 times
...
Ronny
10 months ago
Hmm, this one's a toughie. I'm going to go with A, B, and E. Replication is a cool feature, but it's not as flexible as I'd like. Gotta watch out for those pesky privileges, you know?
upvoted 0 times
Pete
6 months ago
I’m leaning towards A, C, and F. Replication has its limits.
upvoted 0 times
...
Maxima
7 months ago
I agree with A and B, but I’d add E too. Sharing is important!
upvoted 0 times
...
Micaela
7 months ago
I think A, B, and F are the best choices. Flexibility is key!
upvoted 0 times
...
Clay
7 months ago
I like A, B, and E as well. Those privileges can be tricky!
upvoted 0 times
...
...
Marcos
11 months ago
This question is a bit tricky, but I think the answer is A, B, and E. The replication process seems pretty straightforward, but the security aspect with REPLICATIONADMIN privileges is important to note.
upvoted 0 times
Izetta
10 months ago
Yes, you're correct. Those are the key points to remember when it comes to data replication in Snowflake.
upvoted 0 times
...
Shawn
10 months ago
I think you're right, A, B, and E are the correct characteristics of data replication in Snowflake.
upvoted 0 times
...
...
Ezekiel
11 months ago
A, B, and E. Replication is a powerful feature in Snowflake, but it does have its limitations. Good to see the question covers the key points.
upvoted 0 times
Maurine
10 months ago
It's important to grant REPLICATIONADMIN privileges to users for enabling replication.
upvoted 0 times
...
Terrilyn
10 months ago
A, B, and E are correct. Replication in Snowflake is indeed a powerful feature.
upvoted 0 times
...
...

Save Cancel