You are working at RetailNova Corp. , managing a gcp video

Full Certification Question

You are working at RetailNova Corp. , managing a BigQuery table that holds millions of rows of sales transactions , partitioned by date. This table is queried frequently —multiple times per minute—by various applications and users. The queries compute aggregations such as AVG , MAX , and SUM , and they only need data from the past year , although the full historical data must be retained in the base table. The goal is to always return up-to-date results while also minimizing query costs , reducing maintenance overhead , and improving performance . What is the best approach?