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?
Click on the arrows to vote for the correct answer
A. B. C. D.B.
The most appropriate solution to fulfill this request while minimizing cost to the company and effort required on your part is option A, which is to ask the user to run the jobs as batch jobs.
Batch jobs are jobs that are submitted to run at a specific time and are designed to process large amounts of data over a longer period, typically during non-peak hours when system resources are available. This approach ensures that the user's jobs do not interrupt important workloads and minimize the overall impact on the system.
Creating a separate project (option B) or adding the user as a job.user role in the existing project (option C) are both solutions that can potentially work, but they may require additional cost and effort. Creating a separate project would require managing additional resources, and adding a user as a job.user role in the existing project may require additional permissions and access control configurations.
Option D, allowing the user to run jobs when important workloads are not running, is not an optimal solution since it requires manually coordinating with the user to determine the best time to run jobs. This approach may not be practical, especially when dealing with a large number of users.
In summary, the most appropriate solution is to ask the user to run the jobs as batch jobs to ensure that they do not impact important workloads and minimize cost and effort.