Google Cloud Associate Cloud Engineer — Question 255

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 you do? (Choose two.)

Answer options

• A. Use BigQuery BI Engine to analyze the issue.
• B. Use the INFORMATION_SCHEMA views to analyze the underlying issue.
• C. Configure Cloud Trace to analyze the issue.
• D. Search errors in Cloud Audit Logs to analyze the issue.
• E. View errors in Cloud Monitoring to analyze the issue.

Correct answer: B, D

Explanation

The correct answers are B and D. Using INFORMATION_SCHEMA views allows you to gain insights into the query's execution and quota usage, while Cloud Audit Logs provide a record of actions taken that can help identify the cause of the error. Options A, C, and E do not directly address the specific quota-related issue and are less relevant for diagnosing the quotaExceeded error.