SnowPro Core Certification — Question 255

A clustering key was defined on a table, but it is no longer needed.

How can the key be removed?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C, as the command 'ALTER TABLE [TABLE NAME] DROP CLUSTERING KEY' is specifically designed to remove a clustering key from a table. Options A and B are incorrect because they do not use the proper syntax or command for removing a clustering key, and option D, while it may seem logical, is not the correct command in this context.