Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Cloud Engineer Exam - Topic 5 Question 115 Discussion

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?
D) Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.
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.
C) Use Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Florinda
1 month ago
C is too complicated. We need real-time access, not batch jobs.
upvoted 0 times
...
Alexia
1 month ago
Option B seems risky. Distributing private keys isn't secure.
upvoted 0 times
...
Terrilyn
1 month ago
I agree, but A could work too. Dashboards are user-friendly.
upvoted 0 times
...
Cassi
2 months ago
I think option D is the best. It gives the BI team direct access.
upvoted 0 times
...
Bonita
2 months ago
I’m surprised A is even an option, it limits their SQL capabilities.
upvoted 0 times
...
Dyan
2 months ago
Totally agree with D, it’s the simplest way to manage permissions.
upvoted 0 times
...
Tamala
2 months ago
Wait, why not just use option B? Seems risky with private keys.
upvoted 0 times
...
Kenny
2 months ago
I think A is more user-friendly for the team.
upvoted 0 times
...
Cortney
2 months ago
Option D is the best choice for direct access!
upvoted 0 times
...
Ligia
3 months ago
D all the way! Although I do appreciate the humor in C - "Let's make more work for ourselves, yay!"
upvoted 0 times
...
Jame
3 months ago
D is the clear winner here. Gotta love it when the right answer is also the easiest one.
upvoted 0 times
...
Janey
3 months 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
4 months ago
I agree, D is the simplest and most straightforward solution. No need to overcomplicate things.
upvoted 0 times
...
Willow
4 months 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
4 months 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
4 months 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
4 months 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
5 months ago
I think option D sounds familiar because I remember discussing IAM roles and how they control access to BigQuery.
upvoted 0 times
...
Aaron
5 months 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
5 months 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
5 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
5 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
5 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
Anthony
26 days ago
I think option D makes the most sense for access control.
upvoted 0 times
...
...

Save Cancel