Trang chủ Professional Data Engineer 326 / 343
Quay lại bộ đề
Question #326 Topic 1
Your large e-commerce company uses BigQuery for its data warehousing needs. They have two primary types of workloads:• Analyst dashboards: Interactive queries run by business analysts throughout the day, requiring low latency for real-time insights.• ETL jobs: Large, complex batch queries that load and transform data overnight. These jobs are cost-sensitive and can tolerate longer execution times, and they do not have the same performance requirements as the dashboards. Analysts are reporting inconsistent performance of their dashboards, particularly during peak business hours. You need to ensure reliable performance for both workload types while optimizing costs. What should you do?
A
Use BigQuery editions to create an autoscaling reservation with dedicated slots for analyst dashboards, while running ETL jobs with a separate reservation or using the on-demand billing model.
B
Implement a custom autoscaling solution using Cloud Run functions to dynamically adjust available BigQuery slots based on time of day.
C
Migrate all ETL jobs to Cloud SQL to reduce BigQuery’s workload.
D
Run all analyst dashboard queries as interactive queries and configure ETL jobs to run as batch queries.