Question 490
An analyst changes the most common filter from account_id to region_id and the Delta table's current liquid clustering keys are no longer ideal. What validation most directly tests the stated objective?
Explanation
Correct Answer
This outcome directly verifies the scenario's required behavior: liquid clustering can adapt keys as query patterns evolve.
Incorrect Answers
Destructive recreation is unnecessary for this layout change.
Outdated layout may not optimize current query patterns.
Missing statistics weaken data-skipping and planning.