Scenario: You manage two projects that run gcp video
data-engineer-pro video for scenario: You manage two projects that run BigQuery jobs with distinct requirements: Production Project: Runs high-priority jobs
Answer
Full Certification Question
Scenario: You manage two projects that run BigQuery jobs with distinct requirements: Production Project: Runs high-priority jobs that must have the required compute resources available when needed with strict SLAs. Needs a minimum of 300 slots but occasionally spikes to an additional 500 slots. Ad-Hoc Project: Runs analytical queries on demand. Typically uses no more than 200 slots at a time. Ad-hoc queries should be billed based on data scanned, not slot capacity. Question: How should you allocate compute resources to ensure both projects meet their requirements?