Answer: CREATE <object> ... CLONE

The CREATE CLONE command is specifically designed in Snowflake to create zero-copy clones of tables, schemas, or databases. This functionality allows for creating instant, storage-efficient copies that share the underlying data until modifications are made, making it ideal for creating snapshots without duplicating storage. The community discussion shows 100% consensus on option B, with multiple users confirming this is correct and referencing the official Snowflake documentation for CREATE CLONE. No other options were considered viable by the community.

Author: LeetQuiz Editorial Team