Google Associate Cloud Engineer Exam - Topic 5 Question 115 Discussion

Actual exam question for Google's Associate Cloud Engineer exam

Question #: 115
Topic #: 5

[All Associate Cloud Engineer Questions]

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?

ACreate 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.

BCreate a Service Account for the BI team and distribute a new private key to each member of the BI team.

CUse Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse.

DAssign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.

Show Suggested Answer

Suggested Answer: D

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

by Refugia at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janey

3 days ago

D is the correct answer, but I'm still trying to figure out why anyone would choose C. Copying data to a separate warehouse? Really?

upvoted 0 times

...

Adria

8 days ago

I agree, D is the simplest and most straightforward solution. No need to overcomplicate things.

upvoted 0 times

...

Willow

13 days ago

Option D is the way to go. Gives the BI team the necessary access without the hassle of managing individual accounts.

upvoted 0 times

...

Mickie

19 days ago

I recall that using Cloud Scheduler for batch jobs might not be necessary since the data is already streaming into BigQuery.

upvoted 0 times

...

Refugia

24 days ago

I practiced a question about service accounts, but I don't think distributing private keys is the best approach for this scenario.

upvoted 0 times

...

Blythe

29 days ago

I'm not entirely sure, but I feel like creating a Data Studio dashboard could be a good way to visualize the data for the BI team.

upvoted 0 times

...

Merri

1 month ago

I think option D sounds familiar because I remember discussing IAM roles and how they control access to BigQuery.

upvoted 0 times

...

Aaron

1 month ago

I think option D is the way to go. Assigning the IAM role directly to the BI team is the simplest and most secure approach.

upvoted 0 times

...

Bernadine

1 month ago

I'm a bit confused by option C. Copying the data to an internal warehouse seems like overkill if the BI team just needs to query the latest data in BigQuery.

upvoted 0 times

...

Merissa

2 months ago

Option A could work, but I'm worried that a Data Studio dashboard might not give the BI team enough flexibility to run custom queries.

upvoted 0 times

...

Stacey

2 months ago

Hmm, I'm leaning towards option D. Giving the BI team the BigQuery User role seems like the most straightforward way to let them run queries on the latest data.

upvoted 0 times

...

Josue

2 months ago

I'm not sure about this one. I'd need to think through the different options and their implications for data access, security, and latency.

upvoted 0 times

...