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

Google Professional Data Engineer Exam - Topic 2 Question 125 Discussion

You need to set access to BigQuery for different departments within your company. Your solution should comply with the following requirements:Each department should have access only to their data.Each department will have one or more leads who need to be able to create and update tables and provide them to their team.Each department has data analysts who need to be able to query but not modify data.How should you set access to the data in BigQuery?
D) Create a table for each department. Assign the department leads the role of Editor, and assign the data analysts the role of Viewer on the project the table is in.
A) Create a dataset for each department. Assign the department leads the role of OWNER, and assign the data analysts the role of WRITER on their dataset.
B) Create a dataset for each department. Assign the department leads the role of WRITER, and assign the data analysts the role of READER on their dataset.
C) Create a table for each department. Assign the department leads the role of Owner, and assign the data analysts the role of Editor on the project the table is in.

Google Professional Data Engineer Exam - Topic 2 Question 125 Discussion

Actual exam question for Google's Professional Data Engineer exam
Question #: 125
Topic #: 2
[All Professional Data Engineer Questions]

You need to set access to BigQuery for different departments within your company. Your solution should comply with the following requirements:

Each department should have access only to their data.

Each department will have one or more leads who need to be able to create and update tables and provide them to their team.

Each department has data analysts who need to be able to query but not modify data.

How should you set access to the data in BigQuery?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters
Filiberto
5 minutes ago
Option B sounds safer. Analysts shouldn't modify anything.
upvoted 0 times
...
Yan
5 days ago
True, but they need to query too.
upvoted 0 times
...
Tanja
10 days ago
Agreed, but WRITER for analysts? That’s risky.
upvoted 0 times
...
Yan
16 days ago
I think option A is the best. Leads need full control.
upvoted 0 times
...
Chantell
21 days ago
D sounds risky, Viewer access might limit our team’s efficiency.
upvoted 0 times
...
Delsie
26 days ago
C is a no-go, leads need more control than just Editor.
upvoted 0 times
...
Carol
1 month ago
Surprised that anyone would suggest giving analysts WRITER access!
upvoted 0 times
...
Kindra
1 month ago
I think B is better, analysts shouldn't modify anything.
upvoted 0 times
...
Adelaide
1 month ago
Option A seems right, leads need to create/update.
upvoted 0 times
...
Maddie
2 months ago
D? Really? I didn't expect Viewer access for analysts, seems odd!
upvoted 0 times
...
Sharan
2 months ago
C is a no-go, leads should have more control than just Editor.
upvoted 0 times
...
Christiane
2 months ago
Wait, why would you give analysts WRITER access? That's risky!
upvoted 0 times
...
Jess
2 months ago
I think B is better, analysts shouldn't modify anything!
upvoted 0 times
...
Erasmo
2 months ago
Option A seems right, leads need to create/update tables.
upvoted 0 times
...
Elmira
2 months ago
I feel like creating datasets for each department is the right approach, but I can't recall if analysts should really have WRITER access.
upvoted 0 times
...
Emmett
3 months ago
I'm a bit confused about the difference between WRITER and OWNER. Wouldn't giving them OWNER access be safer?
upvoted 0 times
...
Tarra
3 months ago
I think we had a practice question similar to this, and I believe WRITER for leads makes more sense since they need to create tables.
upvoted 0 times
...
Dannette
3 months ago
I remember we discussed the importance of using the correct roles for data access, but I'm not sure if OWNER is too much for the leads.
upvoted 0 times
...

Save Cancel