Answer-first summary for fast verification
Answer: Opt for flat-rate pricing and implement a hierarchical priority system across your projects for better slot allocation.
Adopting flat-rate pricing and setting up a hierarchical priority system for projects allows for centralized purchasing and allocation of slots across the entire organization. This approach ensures that workloads have dedicated computational resources while allowing unused slots to be shared automatically among other workloads. It negates the need to purchase slots for each project individually and avoids the limitations imposed by the 2K on-demand slot quota per project. Reference: [BigQuery Reservations Introduction](https://cloud.google.com/bigquery/docs/reservations-intro).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To manage BigQuery slot allocation effectively within an organization that has multiple business units with varying budgets and priorities, and to avoid the limitation of 2K concurrent on-demand slots per project without adding new projects, what strategy should you adopt?
A
Increase the number of concurrent slots per project via the Quotas page in the Cloud Console.
B
Transform your batch BigQuery queries into interactive ones to optimize slot usage.
C
Opt for flat-rate pricing and implement a hierarchical priority system across your projects for better slot allocation.
D
Create an additional project to circumvent the 2K on-demand slot quota per project.
No comments yet.