Crucial Exams

GCP Professional Data Engineer Practice Question

An enterprise analytics team purchased 200 dedicated BigQuery slots through a reservation. To avoid saturation, they want proactive notification whenever the reservation's slot utilization stays above 90 percent for at least ten minutes while leaving non-critical workloads untouched. They prefer a managed solution and want to avoid writing custom code or scheduled queries. Which approach best meets the requirement?

  • Schedule a BigQuery job every ten minutes that queries INFORMATION_SCHEMA.JOBS_BY_PROJECT for slot usage and publishes the result to a Pub/Sub topic linked to Cloud Monitoring.

  • Define a Cloud Billing budget at 90 percent of expected monthly spend and rely on its e-mail notifications to warn the team.

  • Create a Cloud Monitoring metric-threshold alert on bigquery.googleapis.com/reservation/slot_utilization, filtered to the reservation and set to trigger when the value is ≥ 0.9 for ten consecutive minutes.

  • Export BigQuery Audit Logs to Pub/Sub, run a streaming Dataflow pipeline that calculates slot utilization, and send alerts from a Cloud Function when the threshold is exceeded.

GCP Professional Data Engineer
Maintaining and automating data workloads
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot