A BigQuery query fails with quotaExceeded. Which methods help diagnose the cause? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Query BigQuery INFORMATION_SCHEMA views to inspect quota usage and job metadata., Search Cloud Audit Logs for BigQuery quota and error entries..
Why this is the answer
When a BigQuery query fails due to quotaExceeded, diagnosing the cause involves understanding current usage and historical events. Querying BigQuery INFORMATIONSCHEMA views allows you to inspect detailed metadata about jobs, reservations, and streaming inserts, which can reveal if specific quotas (e.g., concurrent queries, daily query volume, or bytes processed) have been hit. Searching Cloud Audit Logs provides a historical record of API calls, including BigQuery jobs and any associated quota errors, helping identify when and how the quota was exceeded. BigQuery BI Engine is for accelerating query performance, not diagnosing quota issues. Cloud Trace is for distributed tracing of applications, not BigQuery query diagnostics. Cloud Monitoring can show BigQuery error metrics, but Audit Logs offer more specific detail on why a quota was exceeded, and INFORMATIONSCHEMA provides direct insight into BigQuery's internal state regarding quotas.
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