When cloning a database, what is cloned with the database? (Choose two.)
When cloning a database, what is cloned with the database? (Choose two.)
When cloning a database, the cloned objects include existing child objects within the database, such as tables, views, and schemas. Additionally, the privileges on the schemas within the database are also cloned. This ensures that any permissions granted on these schemas are preserved in the cloned database, maintaining the necessary access control for users. Future child objects are not cloned since they do not exist at the time of cloning. Therefore, the correct options are the existing child objects within the database and the privileges on the schemas within the database.
A. Privileges on the database -- This is not correct as source for cloning do not inherit privileges B. Existing child objects within the database --- This is correct C. Future child objects within the database --- This is not correct D. Privileges on the schemas within the database Most Voted -- As Schema is child, it inherits all grants E. Only schemas and tables within the database --- This is not correct
only B is correct. Grants are only inherited if Copy Grants keyword is used while creating a clone.
Database itself plus all child objects. Not the grants on the database itself, but the grants on the child objects are preserved. https://docs.snowflake.com/en/user-guide/object-clone.html#access-control-privileges-for-cloned-objects
B, D For D: 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 https://docs.snowflake.com/en/user-guide/object-clone.html#access-control-privileges-for-cloned-objects
Correct
BD. If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object. https://docs.snowflake.com/en/user-guide/object-clone.html#cloning-and-governance-objects
child objects grants are cloned
A and B are Correct
Correct Answer: BD
B and D are correct
https://docs.snowflake.com/en/user-guide/object-clone
BD is correct answer
All objects and grants are cloned except on the clone level (in this case database)