Answer-first summary for fast verification
Answer: The clone will inherit all privileges except OWNERSHIP from the source object.
The correct answer is C because when using the COPY GRANTS clause in a CREATE TABLE CLONE statement, Snowflake copies all explicit access privileges from the source table to the clone, but does not copy the OWNERSHIP privilege. The ownership of the cloned table is assigned to the role executing the CLONE command. This behavior is confirmed by the Snowflake documentation and supported by the community discussion, where option C has the highest consensus (75%) and upvoted comments reference the official documentation stating that all privileges except OWNERSHIP are copied. Option B is incorrect because it includes OWNERSHIP, which is explicitly not copied. Option A is incorrect because it limits inheritance to only SELECT privileges, whereas COPY GRANTS copies all privileges except OWNERSHIP. Option D is incorrect because it states no privileges are inherited, contradicting the purpose of COPY GRANTS.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
CREATE TABLE new_table CLONE existing_table COPY GRANTS;
CREATE TABLE new_table CLONE existing_table COPY GRANTS;
What will happen to the privileges of any cloned objects?
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.
No comments yet.