An existing clustering key is copied when a table is created using CREATE TABLE ... CLONE.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

An existing clustering key is copied when a table is created using CREATE TABLE ... CLONE.

Explanation:
Cloning a table copies its metadata, not just the data. When you create a zero-copy clone with CREATE TABLE ... CLONE, the new table inherits the source table’s defined clustering key. That means the clone starts with the same clustering key in place as the original, so query pruning behaves the same right after creation. The data itself isn’t physically duplicated; the clone shares the underlying blocks until changes occur. You can modify or drop the clustering key on the clone later if needed, independently of the source.

Cloning a table copies its metadata, not just the data. When you create a zero-copy clone with CREATE TABLE ... CLONE, the new table inherits the source table’s defined clustering key. That means the clone starts with the same clustering key in place as the original, so query pruning behaves the same right after creation. The data itself isn’t physically duplicated; the clone shares the underlying blocks until changes occur. You can modify or drop the clustering key on the clone later if needed, independently of the source.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy