Topic 1 Question 276
2 つ選択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?
Use BigQuery BI Engine to analyze the issue.
Use the INFORMATION_SCHEMA views to analyze the underlying issue.
Configure Cloud Trace to analyze the issue.
Search errors in Cloud Audit Logs to analyze the issue.
View errors in Cloud Monitoring to analyze the issue.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: BD
B & D. Here's why these two methods are crucial for diagnosing quotaExceeded errors in BigQuery:
B. 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.
D. 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.
👍 8RuchiMishra2024/07/16 - 正解だと思う選択肢: BD
a. Query INFORMATION_SCHEMA to identify requests that exceed quotas.
b. See the Cloud Audit Logs for more details on 'quotaExceeded' errors and the context in which they occur.
👍 4BuenaCloudDE2024/07/19 - 正解だと思う選択肢: BD
BD is correct
👍 1user6362024/07/21
シャッフルモード