Which object will NOT be cloned when cloning a schema?

• A. Views
• B. Temporary Table
• C. Permanent Table
• D. Transient Table

Answer: (B)

When you clone a schema in Snowflake, you create a new schema that includes objects tracked in the account catalog at the time of the clone. Only objects that are persisted in the catalog can be cloned; session-scoped or ephemeral objects aren’t part of the clone process.

Views are defined objects and will be cloned as their definitions are stored in the catalog, so the clone will have the same view logic. Permanent tables are also catalog objects with stored metadata and data references, so they are cloned successfully. Transient tables, while not fully durable like permanent tables, still exist as catalog objects and can be cloned.

Temporary tables, on the other hand, exist only for a session and are automatically dropped when the session ends. They aren’t stored in the account catalog, so they cannot be included in a schema clone. If you need a similar structure after cloning, you’d have to recreate the temporary table in the new schema.