ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 575 - SnowPro Core discussion

Report
Export

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

A.

ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY

Answers
A.

ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY

B.

ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY

Answers
B.

ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY

C.

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

Answers
C.

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

D.

ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

Answers
D.

ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

Suggested answer: C

Explanation:

To remove a clustering key that was previously defined on a table in Snowflake, the correct SQL command is ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY. This command removes the existing clustering key from the table, after which Snowflake will no longer re-cluster data based on that key during maintenance operations or after data loading operations.

Show Answer
asked 29/10/2024
pedro blanco
27 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms