Google Professional Data Engineer

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?