A project has a 2000-slot BigQuery reservation. Hundreds of new non-time-sensitive pipelines cause quota errors, with ~1500 queries triggered concurrently at peak. How do you address concurrency issues cost-effectively?
Choose an answer
Tap an option to check your answer.
Correct answer: Run the non-time-sensitive SQL pipelines as batch queries, and run ad-hoc queries as interactive jobs..
Why this is the answer
Running non-time-sensitive SQL pipelines as batch queries is the most cost-effective solution. Batch queries are queued and run when slots are available, preventing quota errors without requiring additional slot purchases. This optimizes slot utilization for background processes. Ad-hoc queries should remain interactive to ensure immediate results for users. Increasing slot capacity (either with baseline 0 or 2000) would incur additional costs, which the question aims to avoid. Changing all queries to interactive would exacerbate the concurrency issues and lead to more quota errors, as interactive queries compete for immediate slot availability.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed