Discuss Snowflake COF-C02 Exam Topic 3 Question 72

What happens when a database is cloned?

AIt does not retain any privileges granted on the source object.

BIt replicates all granted privileges on the corresponding source objects.

CIt replicates all granted privileges on the corresponding child objects.

DIt replicates all granted privileges on the corresponding child schema objects.

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

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Barrie 2 months ago

I lean towards D. Child schema objects are important for replication.

Martina 2 months ago

I feel like A makes sense too. No privileges should carry over.

Brandon 3 months ago

I think B is correct. Cloned databases should keep privileges.

Tashia 3 months ago

C) sounds plausible, but I'm not convinced.

Isadora 3 months ago

Definitely B) for sure, that’s how it works!

Polly 3 months ago

Wait, I thought it kept some privileges?

Shawnda 3 months ago

I disagree, B) seems more accurate to me.

Goldie 3 months ago

A) is correct, no privileges carry over.

Francis 4 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!

Aron 4 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.

Stanford 4 months ago

I recall a practice question where it mentioned that privileges are replicated on source objects. So, I’m leaning towards option B.

Tesha 4 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.

Snowflake COF-C02 Exam - Topic 3 Question 72 Discussion