Google Professional Data Engineer
Get started today
Ultimate access to all questions.
The data analyst team at your company utilizes BigQuery for both ad-hoc queries and scheduled SQL pipelines within a Google Cloud project that has a slot reservation of 2000 slots. Recently, the team has introduced hundreds of new, non time-sensitive SQL pipelines, leading to frequent quota errors. Upon examining the logs, you observe that around 1500 queries are being triggered simultaneously during peak times. You need to address the issue of query concurrency. What should you do?
The data analyst team at your company utilizes BigQuery for both ad-hoc queries and scheduled SQL pipelines within a Google Cloud project that has a slot reservation of 2000 slots. Recently, the team has introduced hundreds of new, non time-sensitive SQL pipelines, leading to frequent quota errors. Upon examining the logs, you observe that around 1500 queries are being triggered simultaneously during peak times. You need to address the issue of query concurrency. What should you do?
Exam-Like
A
Increase the slot capacity of the project with baseline as 0 and maximum reservation size as 3000.
29.7%
B
Comments
Loading comments...