SnowPro Core Certification — Question 1056

How should clustering be used to optimize the performance of queries that run on a very large table?

Answer options

• A. Manually re-cluster the table regularly.
• B. Choose one high cardinality column as the clustering key.
• C. Use the column that is most-frequently used in query select clauses as the clustering key.
• D. Assess the average table depth to identify how clustering is impacting the query.

Correct answer: D

Explanation

Option D is correct because assessing the average table depth can provide insights into how effective clustering is for query performance. Options A, B, and C suggest methods that may not be as effective as directly evaluating the impact of clustering on queries, and they do not address the need to assess performance outcomes.