Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is Snowflake's recommended approach for defining a clustering key on a table with a high-cardinality column, such as an ID_NUMBER column containing 15-digit numeric identifiers?
A
TRUNC(ID_NUMBER, -6)
B
TRUNC(ID_NUMBER, 5)
C
ID_NUMBER*100
D
TO_CHAR(ID_NUMBER)