ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 200 - Associate Cloud Engineer discussion

Report
Export

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 to run the custom SQL queries against the latest data in BigQuery. What should you do?

A.
Create a Data Studio dashboard that uses the related BigQuery tables as a source and give the BI team view access to the Data Studio dashboard.
Answers
A.
Create a Data Studio dashboard that uses the related BigQuery tables as a source and give the BI team view access to the Data Studio dashboard.
B.
Create a Service Account for the BI team and distribute a new private key to each member of the BI team.
Answers
B.
Create a Service Account for the BI team and distribute a new private key to each member of the BI team.
C.
Use Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse.
Answers
C.
Use Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse.
D.
Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.
Answers
D.
Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.
Suggested answer: D

Explanation:

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 new datasets.

https://cloud.google.com/bigquery/docs/access-control

asked 18/09/2024
Louis Flink
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first