Crucial Exams

GCP Professional Data Engineer Practice Question

Your analytics platform launches 180 independent interactive SQL queries in the same BigQuery on-demand project every night at 00:00 to refresh aggregate tables. After recent growth, roughly half of the jobs now fail instantly with the error message "Resources exceeded: Too many concurrent queries for this project." All queries must still complete by 01:00, and you must continue to use on-demand (per-query) pricing. With the least additional operational effort, how should you eliminate the failures and meet the deadline?

  • Change all of the jobs to batch priority so they queue until resources are available and no longer hit the interactive concurrency limit.

  • Request a higher concurrent interactive-query quota for the existing project in the Google Cloud console.

  • Purchase a 500-slot BigQuery capacity reservation for the project and rerun the jobs using capacity pricing instead of on-demand pricing.

  • Create a second Google Cloud project, share the necessary BigQuery datasets, and schedule roughly half of the queries from that project to avoid the per-project concurrency cap.

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