Snowflake
COF-C02 · Question #449
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
The correct answer is A. BINARY C. GEOMETRY. A clustering key can be defined when a table is created by appending a CLUSTER Where each clustering key consists of one or more table columns/expressions, which can be of any data type, except GEOGRAPHY, VARIANT, OBJECT, or ARRAY
Performance Management
Question
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
Options
- ABINARY
- BGEOGRAPHY
- CGEOMETRY
- DOBJECT
- EVARIANT
How the community answered
(41 responses)- A93% (38)
- D5% (2)
- E2% (1)
Explanation
A clustering key can be defined when a table is created by appending a CLUSTER Where each clustering key consists of one or more table columns/expressions, which can be of any data type, except GEOGRAPHY, VARIANT, OBJECT, or ARRAY
Topics
#Clustering#Clustering Keys#Data Types#Performance Optimization
Community Discussion
No community discussion yet for this question.