Your company is moving its data warehouse to BigQuery, and you're responsible for designing the data model. After migrating an on-premises sales data warehouse with a star schema to BigQuery, you notice performance issues when querying the last 30 days of data. According to Google's best practices, what's the most effective way to improve query performance without increasing storage costs?

Real Exam

Combine tables and duplicate data to reduce joins (Denormalize the data).

11.1%

Split the data based on customer IDs to distribute it across multiple nodes (Shard the data by customer ID).

11.1%

Pre-compute and store the results of complex queries in views (Materialize the dimensional data in views).

33.3%

Divide the data into smaller parts based on the transaction date (Partition the data by transaction date).

44.4%

Google Professional Data Engineer