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 t
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 role
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.