ARA-C01 · Question #135
When a database gets cloned, what accesses are replicated?
The correct answer is A. All objects in the database and their child objects(schemas, tables etC.. When a database is cloned in Snowflake, granted privileges on the database object and all its child objects such as schemas and tables are replicated to the clone.
Question
When a database gets cloned, what accesses are replicated?
Options
- AAll objects in the database and their child objects(schemas, tables etC.
- BOnly the data base object access
- COnly the child object access
- DNo access gets replicated
How the community answered
(31 responses)- A94% (29)
- B3% (1)
- D3% (1)
Why each option
When a database is cloned in Snowflake, granted privileges on the database object and all its child objects such as schemas and tables are replicated to the clone.
Snowflake's cloning operation replicates not only the data but also all granted privileges on the source database and every child object it contains - including schemas, tables, views, and other securable objects - preserving the full access control structure in the cloned database.
Cloning does not limit access replication to only the top-level database object; privileges on all child objects are also carried over to the clone.
Cloning does not replicate only child object access; privileges on the parent database object itself are also included in the replication.
Snowflake explicitly replicates granted privileges during a clone operation; the clone inherits all access control metadata from the source objects.
Concept tested: Snowflake database cloning and privilege replication behavior
Source: https://docs.snowflake.com/en/user-guide/object-clone
Topics
Community Discussion
No community discussion yet for this question.