Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
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?