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 COF-C02 Exam - Topic 3 Question 72 Discussion

What happens when a database is cloned?
A) It does not retain any privileges granted on the source object.
B) It replicates all granted privileges on the corresponding source objects.
C) It replicates all granted privileges on the corresponding child objects.
D) It replicates all granted privileges on the corresponding child schema objects.

Snowflake COF-C02 Exam - Topic 3 Question 72 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 72
Topic #: 3
[All COF-C02 Questions]

What happens when a database is cloned?

Show Suggested Answer Hide Answer
Suggested Answer: A

When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References: [COF-C02] SnowPro Core Certification Exam Study Guide


by Anisha at Jun 18, 2026, 05:57 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Barrie
21 days ago
I lean towards D. Child schema objects are important for replication.
upvoted 0 times
...
Martina
27 days ago
I feel like A makes sense too. No privileges should carry over.
upvoted 0 times
...
Brandon
1 month ago
I think B is correct. Cloned databases should keep privileges.
upvoted 0 times
...
Tashia
1 month ago
C) sounds plausible, but I'm not convinced.
upvoted 0 times
...
Isadora
1 month ago
Definitely B) for sure, that’s how it works!
upvoted 0 times
...
Polly
2 months ago
Wait, I thought it kept some privileges?
upvoted 0 times
...
Shawnda
2 months ago
I disagree, B) seems more accurate to me.
upvoted 0 times
...
Goldie
2 months ago
A) is correct, no privileges carry over.
upvoted 0 times
...
Francis
2 months ago
I believe the correct answer is B, but I also remember something about child objects being involved. I should have reviewed that section more closely!
upvoted 0 times
...
Aron
2 months ago
I’m a bit confused about child objects versus child schema objects. I feel like I’ve seen both terms used in different contexts.
upvoted 0 times
...
Stanford
2 months ago
I recall a practice question where it mentioned that privileges are replicated on source objects. So, I’m leaning towards option B.
upvoted 0 times
...
Tesha
3 months ago
I think when a database is cloned, it might not retain privileges, but I'm not entirely sure. I remember something about privileges being tricky.
upvoted 0 times
...

Save Cancel