After CREATE TABLE ... AS SELECT, you can define a clustering key after the table is created.

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

Multiple Choice

After CREATE TABLE ... AS SELECT, you can define a clustering key after the table is created.

Explanation:
You can add or change a clustering key on an existing table even after it’s created, including a table created with CREATE TABLE ... AS SELECT. Clustering keys define how data is organized into micro-partitions to speed up queries, and you’re not limited to defining them only at create time. After the table exists, you can issue ALTER TABLE <table> CLUSTER BY (<columns>) to set or modify the clustering key. Snowflake will use that key for future data and will gradually recluster existing data (or you can run a manual recluster if you need faster results). This is not dependent on LIKE, and it’s valid to apply clustering after a CTAS.

You can add or change a clustering key on an existing table even after it’s created, including a table created with CREATE TABLE ... AS SELECT. Clustering keys define how data is organized into micro-partitions to speed up queries, and you’re not limited to defining them only at create time. After the table exists, you can issue ALTER TABLE

CLUSTER BY () to set or modify the clustering key. Snowflake will use that key for future data and will gradually recluster existing data (or you can run a manual recluster if you need faster results). This is not dependent on LIKE, and it’s valid to apply clustering after a CTAS.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy

© Passetra by Kaluba Technologies Incorporated. 2026 All rights reserved.