Exam Professional Cloud Developer topic 1 question 24 discussion

Option A makes the most sense B is wrong since it will incur more costs which is not what the qn wants C is definitely out as creating roles is not what the qn is asking for D is wrong as it would not minimise effort

Answer is A https://cloud.google.com/bigquery/docs/running-queries#batch

As read from google cloud docs "Batch query jobs. With these jobs, BigQuery queues each batch query on your behalf and then starts the query when idle resources are available, usually within a few minutes."

A. Ask the user to run the jobs as batch jobs. Running BigQuery jobs as batch jobs is a good solution when there is no concern about how long it takes to complete these jobs. Batch jobs are executed when BigQuery has available resources, which ensures that they do not interfere with high-priority workloads. This is also a cost-effective solution since it does not require additional resources or the overhead of managing a separate project. BigQuery automatically prioritizes interactive jobs over batch jobs, so important workloads are less likely to be interrupted.

Batch jobs in BigQuery are not subject to the usual quota limits and do not count towards your concurrent rate limit, which makes them suitable for running large queries and reducing costs. They are executed when system resources become available, so there might be a delay, but since the user isn’t concerned about the time it takes to run these jobs, this would be a suitable solution

Correct Answer:A

Definitly the correct answer is A

Option A is the correct answer. By running the jobs as batch jobs, the user can specify a priority level for their jobs, allowing them to be run when system resources are available. This minimizes the impact on important workloads and allows the user to run their jobs without interrupting other users. Additionally, batch jobs are generally less expensive to run than interactive queries, so this option would also minimize cost to the company. Option B is not a good solution because it would involve creating a separate project for the user to run their jobs, which would add unnecessary complexity and effort. Option C is not a good solution because the job.user role does not provide any additional permissions beyond those of the bigquery.user role, which the user likely already has. Option D is not a good solution because it would require manual intervention to determine when important workloads are not running, which would be difficult to manage and could lead to delays in running the user's jobs.

A is correct

A is correct

A is right

A is more suitable answer here

A is best answer