Answer-first summary for fast verification
Answer: ALTER TABLE [TABLE NAME] DROP CLUSTERING KEY
The correct answer is C because the Snowflake documentation explicitly states that clustering keys are removed using the DROP CLUSTERING KEY syntax in an ALTER TABLE statement. The community discussion shows 100% consensus on option C, with multiple users citing the official Snowflake documentation that confirms this syntax. Options A, B, and D use incorrect keywords (PURGE, DELETE, REMOVE) that are not valid Snowflake SQL commands for removing clustering keys.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
ALTER TABLE <table_name> DROP CLUSTERING KEY;
ALTER TABLE <table_name> DROP CLUSTERING KEY;
A
ALTER TABLE [TABLE NAME] PURGE CLUSTERING KEY
B
ALTER TABLE [TABLE NAME] DELETE CLUSTERING KEY
C
ALTER TABLE [TABLE NAME] DROP CLUSTERING KEY
D
ALTER TABLE [TABLE NAME] REMOVE CLUSTERING KEY