Exam SnowPro Core topic 1 question 140 discussion

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

A and B are Correct

Correct Answer: BD

B and D are correct

https://docs.snowflake.com/en/user-guide/object-clone

only B is correct. Grants are only inherited if Copy Grants keyword is used while creating a clone.

Correct

BD is correct answer

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

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

All objects and grants are cloned except on the clone level (in this case database)

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