Answer-first summary for fast verification
Answer: Review administrative resource charts for slot usage and job performance trends. Additionally, query the INFORMATION_SCHEMA for detailed performance metrics.
The correct approach is to review administrative resource charts for a visual analysis of slot utilization and job performance over time, which can highlight patterns or bottlenecks. Querying the INFORMATION_SCHEMA provides detailed insights into query performance, such as execution times and slot usage, helping to identify specific issues. Other options either focus on resource allocation without troubleshooting (A and D) or track irrelevant data like access grants (B).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a BigQuery admin, you've noticed your team's ad hoc queries and reports in tools like Looker are running slower than usual. You suspect job queuing or slot contention might be the culprit. What's the best approach to investigate and address these performance issues?
A
Set up Cloud Monitoring to track BigQuery metrics and configure alerts for high slot usage.
B
Utilize Cloud Logging to monitor changes or deletions in access grants on tagged resources.
C
Review administrative resource charts for slot usage and job performance trends. Additionally, query the INFORMATION_SCHEMA for detailed performance metrics.
D
Implement slot reservations in your project to guarantee sufficient query processing capacity and prioritize slower queries.
No comments yet.