When a database gets cloned, what accesses are replicated

When a database gets cloned, what accesses are replicated
A . All objects in the database and their child objects(schemas, tables etc)
B. Only the data base object access
C. Only the child object access
D. No access gets replicated

View Answer

Answer: A

Explanation:

A cloned object does not retain any granted privileges on the source object itself (i.e. clones do not automatically have the same privileges as their sources). A system administrator or the owner of the cloned object must explicitly grant any required privileges to the newly-created clone.

However, if the source object is a database or schema, for child objects contained in the source, the clone replicates all granted privileges on the corresponding child objects:

For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc. https://docs.snowflake.com/en/user-guide/object-clone.html#access-control-privileges-for-cloned-objects Additional clarification based on a question from a student

When a database is cloned, the roles are not cloned for the database, Only the child objects of the original database(schemas, tables etc) will retain the privileges in the cloned DB.

Similarly, when a schema is cloned, the roles are not retained to the cloned schema. Only the child object of the original schema(ie table) would retain the privileges from the original schema.