QuestionQ98
VerifiedDesigning data processing systemsYour large e-commerce company relies on BigQuery for its data warehousing requirements. It has two main workload types:
- Analyst dashboards: Interactive queries that business analysts run throughout the day and that require low latency for real-time insights.
- ETL jobs: Large, complex batch queries that load and transform data overnight. These jobs are cost-sensitive, can tolerate longer execution times, and do not have the same performance requirements as the dashboards.
Analysts report inconsistent dashboard performance, especially during peak business hours. You must ensure dependable performance for both workload types while optimizing costs. What should you do?
Community Discussion