Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 784

When a database is cloned, which objects in the clone inherit all granted privileges from the source object? (Choose two.)

    Correct Answer: C, D

    When a database is cloned, the objects that inherit all granted privileges from the source object are schemas and tables. This is because, within a database, the privileges on child objects such as schemas and tables are inherited by their respective clones. The clone of the database itself does not inherit the privileges granted on the source database, but the individual contained objects, such as schemas and tables, do inherit these privileges.

Discussion
RajivnbOptions: CD

Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.

Ram9198Options: CD

Internal named stages are not cloned.

PawanpantOptions: CD

It's CD - Only child objects inherit the privileges. 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: For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc.

Aparna98Options: CD

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: For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc. Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container. c d

0e504b5Options: DE

DE https://docs.snowflake.com/en/user-guide/object-clone#access-control-privileges-for-cloned-objects Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container. This rules out BC. A can't be cloned. This leaves us DE.

HeetecOptions: BC

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