SnowPro Core Certification — Question 1320

What happens when a database is cloned?

Answer options

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

Correct answer: C

Explanation

The correct answer is C because when a database is cloned, it ensures that all privileges granted on the child objects are preserved. Options A and B are incorrect as they either state that privileges are not retained or suggest that only source objects are considered, which is not accurate. Option D is also wrong because it specifies child schema objects, which is more specific than what is generally applicable in this context.