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
Maddie
1 day ago
D? Really? I didn't expect Viewer access for analysts, seems odd!
upvoted 0 times
...
Sharan
7 days ago
C is a no-go, leads should have more control than just Editor.
upvoted 0 times
...
Christiane
12 days ago
Wait, why would you give analysts WRITER access? That's risky!
upvoted 0 times
...
Jess
17 days ago
I think B is better, analysts shouldn't modify anything!
upvoted 0 times
...
Erasmo
22 days ago
Option A seems right, leads need to create/update tables.
upvoted 0 times
...
Elmira
27 days 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
1 month 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
1 month 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
1 month 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