Answer-first summary for fast verification
Answer: Clone the table with the COPY GRANTS command.
The correct answer is A because the CLONE command with COPY GRANTS parameter is specifically designed for this purpose. According to Snowflake documentation and the community consensus (with 100% agreement and upvoted comments), when COPY GRANTS is specified in a CREATE TABLE ... CLONE statement, it copies all privileges except OWNERSHIP from the source table to the new clone. This is the most efficient and recommended approach as it's a built-in feature requiring minimal steps. Option B is incorrect because ALTER TABLE cannot copy grants. Option C is inefficient as it clones the entire schema and requires dropping unwanted tables. Option D is manual and error-prone compared to the automated COPY GRANTS functionality.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the recommended method to create a cloned table that also retains the same grants as the source table?
A
Clone the table with the COPY GRANTS command.
B
Use an ALTER TABLE command to copy the grants.
C
Clone the schema then drop the unwanted tables.
D
Create a script to extract grants and apply them to the cloned table.
No comments yet.