ExamGecko
Question list
Search
Search

Question 479 - SnowPro Core discussion

Report
Export

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

A.

BINARY

Answers
A.

BINARY

B.

GEOGRAPHY

Answers
B.

GEOGRAPHY

C.

GEOMETRY

Answers
C.

GEOMETRY

D.

OBJECT

Answers
D.

OBJECT

E.

VARIANT

Answers
E.

VARIANT

Suggested answer: A, C

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

asked 29/10/2024
Emma Buchanan
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first