A partitioned BigQuery table stores daily transactions. A report only needs a narrow date range and should avoid unnecessary scanned partitions. Which approach best fits?

1. Perform a dry run and set an appropriate maximum bytes billed where supported.
2. Filter on the relevant partition column using a pruning-compatible predicate.
3. Evaluate clustering on the frequently filtered identifier and measure the effect.
4. Evaluate a compatible materialized view.