Quiz 3 Question 4

A social media company uses a single, massive BigQuery table to store all user events (likes, posts, comments), which is partitioned by day. The Data Science team needs to run complex machine learning training queries that scan months of historical data. At the same time, the Product Analytics team runs many small, concurrent dashboard queries that typically look at the last 7 days of data. The analytics dashboards are becoming slow whenever the ML training jobs are running. What is the best way to ensure the Product Analytics team's dashboards remain fast and responsive without stopping the Data Science team's work?