
Answer-first summary for fast verification
Answer: Tables, Named File Formats, Schemas
The question asks which object types can be cloned in Snowflake, requiring selection of four correct options. Based on Snowflake documentation and community consensus (76% support for ABCE with high upvotes), Tables (A), Named File Formats (B), Schemas (C), and Databases (E) are cloneable. Tables, Schemas, and Databases support zero-copy cloning, while Named File Formats are schema objects that can be cloned. Shares (D) cannot be cloned as they represent data sharing mechanisms controlled by grants, not copies. Users (F) cannot be cloned due to uniqueness constraints on user accounts and permissions. The community discussion strongly supports ABCE, with detailed reasoning that Shares and Users are not cloneable objects in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.