Your company uses BigQuery to store and analyze data. Upon submitting your query in BigQuery, the query fails with a quotaExceeded error. You need to diagnose the issue causing the error. What should

Question

Options

• AUse BigQuery BI Engine to analyze the issue.
• BUse the INFORMATION_SCHEMA views to analyze the underlying issue.
• CConfigure Cloud Trace to analyze the issue.
• DSearch errors in Cloud Audit Logs to analyze the issue.
• EView errors in Cloud Monitoring to analyze the issue.

• A
  4% (1)
• B
  68% (19)
• C
  18% (5)
• E
  11% (3)

Explanation

INFORMATION_SCHEMA Views: BigQuery's INFORMATION_SCHEMA provides metadata about datasets, tables, and jobs. Relevant views like JOBS_BY_PROJECT and JOBS_BY_USER can help you analyze recent queries, their resource consumption (bytes processed, slots used), and any errors encountered. This can reveal which queries are exceeding quotas and what type of quota (e.g., query size, daily limit) is being exceeded. Cloud Audit Logs: Audit logs record all API calls and administrative actions within your GCP projects. By searching for quotaExceeded errors in the audit logs, you can see the exact error messages, timestamps, and potentially the queries that triggered the error. This helps pinpoint the specific resources and actions causing the issue.

No community discussion yet for this question.