SnowPro Core Certification — Question 1176

This command is executed:

CREATE TABLE new_table CLONE existing_table COPY GRANT;

What will happen to the privileges of any cloned objects?

Answer options

• A. The clone will only inherit SELECT privileges from the source object.
• B. The clone will inherit all privileges, including OWNERSHIP, from the source object.
• C. The clone will inherit all privileges except OWNERSHIP from the source object.
• D. The clone will not inherit any privileges from the source object.

Correct answer: C

Explanation

The correct answer is C because cloning a table in this manner allows the new table to inherit all privileges except for OWNERSHIP, which is not transferred. Options A and B are incorrect as they misrepresent the privileges inherited, while option D incorrectly states that no privileges are inherited.