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

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
Dyan
1 day ago
Totally agree with D, it’s the simplest way to manage permissions.
upvoted 0 times
...
Tamala
7 days ago
Wait, why not just use option B? Seems risky with private keys.
upvoted 0 times
...
Kenny
12 days ago
I think A is more user-friendly for the team.
upvoted 0 times
...
Cortney
17 days ago
Option D is the best choice for direct access!
upvoted 0 times
...
Ligia
22 days 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
27 days ago
D is the clear winner here. Gotta love it when the right answer is also the easiest one.
upvoted 0 times
...
Janey
2 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
2 months ago
I agree, D is the simplest and most straightforward solution. No need to overcomplicate things.
upvoted 0 times
...
Willow
2 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
2 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
2 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
2 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
3 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
3 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
3 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
3 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
3 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
4 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
...

Save Cancel