nerdexam
SnowflakeSnowflake

COF-C02 · Question #449

COF-C02 Question #449: Real Exam Question with Answer & Explanation

The correct answer is A: BINARY. 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

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.

Full COF-C02 PracticeBrowse All COF-C02 Questions