
Ultimate access to all questions.
The data analyst team at your company uses BigQuery for both ad-hoc queries and scheduled SQL pipelines in a Google Cloud project with a slot reservation of 2000 slots. Recently, the addition of many non time-sensitive SQL pipelines has led to frequent quota errors, with logs showing around 1500 queries running concurrently during peak hours. What is the best approach to alleviate these quota errors?
A
Increase the slot capacity of the project with a baseline of 0 and a maximum reservation size of 3000.
B
Update SQL pipelines to run as batch queries, and run ad-hoc queries as interactive query jobs.
C
Increase the slot capacity of the project with a baseline of 2000 and a maximum reservation size of 3000.
D
Update both SQL pipelines and ad-hoc queries to run as interactive query jobs.