Answer-first summary for fast verification
Answer: Adopt flat-rate pricing and implement a hierarchical priority system across your projects for efficient slot allocation.
The optimal solution involves switching to flat-rate pricing and setting up a hierarchical priority system for your projects. This approach leverages BigQuery Reservations for workload management, allowing you to allocate purchased slots to specific workloads. This ensures dedicated computational resources for high-priority workloads while unused slots are automatically shared across other workloads. Additionally, centralized purchasing enables slot allocation for the entire organization without the need for per-project purchases. Reference: [BigQuery Reservations Introduction](https://cloud.google.com/bigquery/docs/reservations-intro).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your organization faces a challenge with BigQuery slots: a quota of 2K concurrent on-demand slots per project is causing delays, and adding new projects isn't an option. With multiple business units having varied budgets and priorities, what's the best strategy to manage this?
A
Convert batch BigQuery queries to interactive ones to optimize slot usage.
B
Establish a new project to circumvent the 2K on-demand slot quota per project.
C
Adopt flat-rate pricing and implement a hierarchical priority system across your projects for efficient slot allocation.
D
Adjust the quota settings in the Cloud Console to allow more concurrent slots per project.
No comments yet.