Snowflake SnowPro Certification Practice Test

A cloned object retains all granted privileges of the source object. True or False?

1. True

2. False

3. Only for certain object types

4. It varies based on user permissions

The correct answer is: False

Cloned objects in Snowflake do not retain the privileges of the source object. When you clone an object, such as a table or schema, you create a new entity that is a snapshot of the original at that moment in time. However, this new object does not carry over any of the privileges that had been granted on the source object. Instead, the privileges must be explicitly granted to the cloned object after its creation. This distinction is crucial for understanding how object management works in Snowflake, particularly when considering access control. Users need to be aware that cloning is primarily a data operation and does not inherently provide access to the cloned object based on the original object's privileges. Consequently, any role or user wishing to access the cloned object will have to have privileges re-established to maintain the desired security and access protocols.