Skip to content
PCA Practice
Q92

A BigQuery team is scanning much more data than needed. Which query design change helps most?

  1. AAdd more views only
  2. BPartition and cluster tables appropriately
  3. CUse SELECT * everywhere
  4. DStore data in PDFs
Show answer

Answer: B

Partitioning and clustering can significantly reduce scanned data and cost.

← Q91Practice this topicQ93 →