Exam Professional Data Engineer topic 1 question 316 discussion

C. Build materialized views on top of the sales table to aggregate data at the day and month level. Materialized views are precomputed views that cache the results of a query, which can significantly improve query performance and reduce costs by avoiding repeated computation. They automatically update with changes to the base table, ensuring data freshness without additional maintenance. https://cloud.google.com/bigquery/docs/materialized-views-intro

C is the answer. Materialized Views: Materialized views in BigQuery are precomputed views that store the results of a query, allowing for much faster query execution because BigQuery doesn’t need to recompute the results each time the query is run. The results are stored in a persistent table, which significantly improves performance for repeated queries that aggregate the same data. In this case, you can create materialized views that aggregate the sales data at the day and month levels. This will reduce the amount of data that needs to be processed for each query and speed up the response time. Materialized views also lower costs because BigQuery only scans the precomputed data in the materialized view, rather than the full 50 TB sales history table.