Question 90
A huge table has poor date-filter locality and frequent highly selective range predicates. Which design property could improve organization?
Explanation
Correct Answer
Correct—this case calls for a clustering expression based on filter patterns. Clustering key influences data organization for selective filters on very large tables.
Incorrect Answers
Incorrect here—Automatic micro-partitioning organizes table data into compressed columnar micro-partitions, whereas the stated requirement is a clustering expression based on filter patterns.
Incorrect here—Partition metadata pruning skips micro-partitions when filtering constraints rule out their values, whereas the stated requirement is a clustering expression based on filter patterns.
Incorrect here—Automatic clustering maintains the clustering organization of tables with defined clustering keys, whereas the stated requirement is a clustering expression based on filter patterns.