Answer-first summary for fast verification
Answer: Run the report generation queries in batch mode.
A. Incorrect. Running all queries in interactive mode will lead to the same error. B. Incorrect. Reserving BigQuery slots will not avoid the error because concurrent query limits still apply. C. Correct. Offloading the report generation queries to batch mode reduces the number of concurrent queries. D. Incorrect. Queries run on views also count towards the concurrent queries limit, therefore, they do not solve this issue.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a team of data analysts that run queries interactively on BigQuery during work hours. You also have thousands of report generation queries that run simultaneously. You often see an error: Exceeded rate limits: too many concurrent queries for this project_and_region.
A
Run all queries in interactive mode.
B
Create a yearly reservation of BigQuery slots.
C
Run the report generation queries in batch mode.
D
Create a view to run the queries.