ASSOCIATE-CLOUD-ENGINEER · Question #246
You are managing a project for the Business Intelligence (BI) department in your company. A data pipeline ingests data into BigQuery via streaming. You want the users in the BI department to be able…
The correct answer is D. Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI. roles/bigquery.user When applied to a dataset, this role provides the ability to read the dataset's metadata and list tables in the dataset. When applied to a project, this role also provides the ability to run jobs, including queries, within the project. A member with this…
Question
Options
- ACreate a Data Studio dashboard that uses the related BigQuery tables as a source and give the
- BCreate a Service Account for the BI team and distribute a new private key to each member of the
- CUse Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI
- DAssign the IAM role of BigQuery User to a Google Group that contains the members of the BI
How the community answered
(16 responses)- B6% (1)
- D94% (15)
Explanation
roles/bigquery.user When applied to a dataset, this role provides the ability to read the dataset's metadata and list tables in the dataset. When applied to a project, this role also provides the ability to run jobs, including queries, within the project. A member with this role can enumerate their own jobs, cancel their own jobs, and enumerate datasets within a project. Additionally, allows the creation of new datasets within the project; the creator is granted the BigQuery Data Owner role (roles/bigquery.dataOwner) on these
Topics
Community Discussion
No community discussion yet for this question.