Answer-first summary for fast verification
Answer: It replicates all granted privileges on the corresponding child objects.
When a database is cloned in Snowflake, the clone inherits all granted privileges on the clones of all child objects contained in the source database (such as schemas, tables, views, etc.), but it does not inherit privileges granted directly on the source database container itself. Option C correctly states this behavior, which is supported by the community discussion with 100% consensus and references to Snowflake documentation. Option A is incorrect because privileges on child objects are retained. Option B is incorrect because privileges on the source container are not replicated. Option D is incorrect as it specifies 'child schema objects' which is too narrow; the inheritance applies to all child objects, not just schema-level ones.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When a database is cloned in Snowflake, what is the outcome?
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.