Question 220 of 307
Single answerThe data analyst team at your company uses BigQuery for ad-hoc queries and scheduled SQL pipelines in a Google Cloud project with a slot reservation of 2000 slots. However, with the recent introduction of hundreds of new non time-sensitive SQL pipelines, the team is encountering frequent quota errors. You examine the logs and notice that approximately 1500 queries are being triggered concurrently during peak time. You need to resolve the concurrency issue. What should you do?
AIncrease the slot capacity of the project with baseline as 0 and maximum reservation size as 3000.
✓BUpdate SQL pipelines to run as a batch query, and run ad-hoc queries as interactive query jobs.
CIncrease the slot capacity of the project with baseline as 2000 and maximum reservation size as 3000.
DUpdate SQL pipelines and ad-hoc queries to run as interactive query jobs.
✓
Correct Answer: B
Update SQL pipelines to run as a batch query, and run ad-hoc queries as interactive query jobs.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.