Answer-first summary for fast verification
Answer: Add all users to a group. Grant the group the roles of BigQuery jobUser on the billing project and BigQuery dataViewer on the projects that contain the data.
The correct answer is C. For ensuring that all queries are billed to a single project while users can query but not edit the datasets, users should be granted the roles of BigQuery jobUser on the billing project and BigQuery dataViewer on the projects containing the data. The role BigQuery jobUser allows users to run jobs (including queries) in the billing project, which fulfills the requirement that all query costs are incurred there. The role BigQuery dataViewer only provides read access to the datasets without granting edit permissions, meeting the requirement that users should not be able to edit the data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company is utilizing Google BigQuery as its enterprise data warehouse solution. In this setup, the data is distributed across multiple Google Cloud projects. However, the requirement is that all BigQuery queries should be billed to a single, centralized billing project. It is crucial to ensure that no query costs are incurred on any of the projects where the data resides. Furthermore, users must have the capability to run queries on the datasets without having the permissions to edit them. How should you configure the users' access roles to meet these requirements?
A
Add all users to a group. Grant the group the role of BigQuery user on the billing project and BigQuery dataViewer on the projects that contain the data.
B
Add all users to a group. Grant the group the roles of BigQuery dataViewer on the billing project and BigQuery user on the projects that contain the data.
C
Add all users to a group. Grant the group the roles of BigQuery jobUser on the billing project and BigQuery dataViewer on the projects that contain the data.
D
Add all users to a group. Grant the group the roles of BigQuery dataViewer on the billing project and BigQuery jobUser on the projects that contain the data.