GOOGLE-PROFESSIONAL-CLOUD-DEVELOPER practice question 20 of 35
Your company has a BigQuery data mart that provides analytics information to hundreds of employees. One user of wants to run jobs without interrupting important workloads. This user isn't concerned about the time it takes to run these jobs. You want to fulfill this request while minimizing cost to the company and the effort required on your part. What should you do?
Full set: 265 questionsBigQuery offers two query priorities: interactive (default) and batch. Batch queries are designed for non-time-sensitive workloads. They are queued and executed as idle resources become available in the BigQuery shared resource pool. This ensures they do not compete for slots with higher-priority interactive queries, thus preventing any interruption to important workloads. This approach directly fulfills the user's request, requires minimal effort (the user simply specifies the job as a batch job), and incurs no additional cost, as batch queries are billed at the same on-demand rate as interactive queries.
B. Creating a separate project introduces significant administrative overhead for setup, billing, and permissions management, and could increase costs if separate resource commitments are needed. This violates the "minimize effort" and "minimize cost" requirements.
C. The roles/bigquery.jobUser role only grants the permission to run jobs. It does not influence the job's priority or its impact on other workloads. The user likely already has this permission.
D. This is a manual, policy-based approach that is inefficient and unreliable. It requires the user to monitor system load, which is impractical and contradicts the goal of minimizing effort.
1. Google Cloud Documentation, "Run interactive and batch query jobs": "BigQuery also offers batch query jobs. These are queries that BigQuery queues and starts as soon as idle resources are available, usually within a few minutes... If BigQuery has not started the query within 24 hours, BigQuery changes the job priority to interactive... Batch queries don't count towards your concurrent rate limit for on-demand queries, which can make it easier to start many queries at once." This confirms that batch jobs are queued and use idle resources, preventing interference with interactive jobs.
2. Google Cloud Documentation, "Introduction to BigQuery jobs": "You can run two types of query jobs in BigQuery: interactive query jobs: These are the default. BigQuery executes these jobs immediately. batch query jobs: BigQuery queues each batch query job and starts the query when idle resources are available." This section explicitly defines the two job types and their execution behavior, supporting the choice of batch jobs for non-urgent tasks.
3. Google Cloud Documentation, "BigQuery pricing - On-demand analysis pricing": The on-demand pricing model is based on the number of bytes processed by the queries. The documentation does not specify a different rate for batch versus interactive queries, confirming that using batch mode does not increase the per-query cost. This supports the "minimize cost" requirement.
Keep practicing
Take the free GOOGLE-PROFESSIONAL-CLOUD-DEVELOPER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other GOOGLE-PROFESSIONAL-CLOUD-DEVELOPER practice questions
- Question 1You have an application controlled by a managed instance group. When you deploy a new ver…
- Question 2Your service adds text to images that it reads from Cloud Storage. During busy times of t…
- Question 3You have been tasked with planning the migration of your company’s application from on-pr…
- Question 4You plan to make a simple HTML application available on the internet. This site keeps inf…
- Question 5HipLocal's APIs are showing occasional failures, but they cannot find a pattern. They wan…
- Question 6Your company has created an application that uploads a report to a Cloud Storage bucket. …
