Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 871

While clustering a table, columns with which data types can be used as clustering keys? (Choose two.)

    Correct Answer: A, C

    While clustering a table, the columns used as clustering keys can be of any data type except GEOGRAPHY, VARIANT, OBJECT, or ARRAY. Therefore, the applicable data types for clustering keys given the options are BINARY and GEOMETRY.

Discussion
BobFarOptions: AC

AC correct. (Binary & Geometry) It can be any datatype except GEOGRAPHY. VARIANT. OBJECT. ARRAY.

BobFar

https://docs.snowflake.com/en/user-guide/tables-clustering-keys#defining-a-clustering-key-for-a-table

kayuhanbidukOptions: AC

AC. any data type except GEOGRAPHY, VARIANT, OBJECT, or ARRAY

HeetecOptions: AC

AC correct - 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 https://docs.snowflake.com/en/user-guide/tables-clustering-keys

AmitsnowflakeOptions: AE

except geometry all are correct ans