
Ultimate access to all questions.
After resolving the small files problem with optimize, your queries are still slow. The column transactionId, used for filtering, has high cardinality and is auto-incrementing. Which Delta optimization can you enable to effectively filter data based on this column?
A
Increase the driver size and enable delta optimization
B
Perform Optimize with Zorder on transactionId
C
Create BLOOM FILTER index on the transactionId
D
Increase the cluster size and enable delta optimization
E
transactionId has high cardinality, you cannot enable any optimization.