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