Answer-first summary for fast verification
Answer: Switch to flat-rate pricing and establish a hierarchical priority model for your projects.
The correct answer is C. Switching to flat-rate pricing would allow you to ensure a consistent level of service and avoid running into the on-demand slot quota per project. Additionally, by establishing a hierarchical priority model for your projects, you could allocate resources based on the specific needs and priorities of each business unit. This ensures that the most critical queries are executed first. This approach is more effective than converting batch queries to interactive queries or creating additional projects because it directly addresses the slot quota issue without adding unnecessary complexity.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As the head of Business Intelligence at a large enterprise company comprising multiple business units with varying priorities and budgets, you are currently using on-demand pricing for BigQuery with a quota set at 2,000 concurrent on-demand slots per project. Recently, some users in your organization have experienced difficulties obtaining slots to execute their queries. You aim to resolve this issue without adding new projects to your account. What actions should you take?
A
Convert your batch BQ queries into interactive BQ queries.
B
Create an additional project to overcome the 2K on-demand per-project quota.
C
Switch to flat-rate pricing and establish a hierarchical priority model for your projects.
D
Increase the amount of concurrent slots per project at the Quotas page at the Cloud Console.
No comments yet.