A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

The correct answer is C. ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY. The correct DDL syntax to remove a clustering key from a Snowflake table is: ALTER TABLE <table_name> DROP CLUSTERING KEY. Snowflake follows standard SQL DDL conventions where DROP is used to remove object properties or definitions. PURGE, DELETE, and REMOVE are not valid…

Performance Management

Question

Options

AALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY
BALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY
CALTER TABLE <TABLE NAME> DROP CLUSTERING KEY
DALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

How the community answered

(45 responses)

A
4% (2)
C
93% (42)
D
2% (1)

Explanation

The correct DDL syntax to remove a clustering key from a Snowflake table is: ALTER TABLE <table_name> DROP CLUSTERING KEY. Snowflake follows standard SQL DDL conventions where DROP is used to remove object properties or definitions. PURGE, DELETE, and REMOVE are not valid keywords in this context and would produce a syntax error.

Topics

#Clustering Key#Table Management#SQL DDL

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice