Question 500
A filter's range excludes thousands of partitions before reading rows. Which information allows that?
Explanation
Correct Answer
The scenario calls for micro-partition metadata: Metadata statistics support partition pruning and planning of data access.
Incorrect Answers
Persisted query result cache may return eligible identical result sets without rerunning the query, rather than satisfying micro-partition metadata.
Warehouse local cache retains some previously read data on active warehouse nodes, rather than satisfying micro-partition metadata.
Materialized view maintains stored query-derived results for eligible operations, rather than satisfying micro-partition metadata.