Topic 1 Question 142
Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?
Create a Cloud Monitoring dashboard based on the BigQuery metric query/scanned_bytes
Create a Cloud Monitoring dashboard based on the BigQuery metric slots/allocated_for_project
Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Cloud Monitoring dashboard based on the custom metric
Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Cloud Monitoring dashboard based on the custom metric
ユーザの投票
コメント(6)
- 正解だと思う選択肢: B
B the below is related to the question. https://cloud.google.com/blog/topics/developers-practitioners/monitoring-bigquery-reservations-and-slot-utilization-information_schema
👍 4John_Pongthorn2022/09/12 B ,the another is related to the question as well. https://cloud.google.com/bigquery/docs/reservations-monitoring#viewing-slot-usage
👍 3John_Pongthorn2022/09/12- 正解だと思う選択肢: B
The correct answer is B. You should create a Cloud Monitoring dashboard based on the BigQuery metric slots/allocated_for_project.
This metric represents the number of BigQuery slots allocated for a project. By creating a Cloud Monitoring dashboard based on this metric, you can monitor the slot usage within each project in your organization. This will allow each team to monitor their own slot usage and ensure that they are not exceeding their allocated quota.
Option A is incorrect because the query/scanned_bytes metric represents the number of bytes scanned by BigQuery queries, not the slot usage.
Option C is incorrect because it involves creating a log export for each project and using a custom metric based on the totalSlotMs field. While this may be a valid way to monitor slot usage, it is more complex than simply using the slots/allocated_for_project metric.
Option D is also incorrect because it involves creating an aggregated log export at the organization level, which is not necessary for monitoring slot usage within individual projects.
👍 3saurabhsingh4k2022/12/20
シャッフルモード