Topic 1 Question 239
The 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?
Increase the slot capacity of the project with baseline as 0 and maximum reservation size as 3000.
Update SQL pipelines to run as a batch query, and run ad-hoc queries as interactive query jobs.
Increase the slot capacity of the project with baseline as 2000 and maximum reservation size as 3000.
Update SQL pipelines and ad-hoc queries to run as interactive query jobs.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: B
- BigQuery allows you to specify job priority as either BATCH or INTERACTIVE.
- Batch queries are queued and then started when idle resources are available, making them suitable for non-time-sensitive workloads.
- Running ad-hoc queries as interactive ensures they have prompt access to resources.
👍 3raaad2024/01/04 - 正解だと思う選択肢: B
B. Update SQL pipelines to run as a batch query, and run ad-hoc queries as interactive query jobs.
👍 2scaenruy2024/01/03
シャッフルモード