Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are tasked with configuring access permissions to BigQuery for various departments within your organization. The solution should adhere to these specific requirements:
✑ Each department must have exclusive access to their respective data and no access to data belonging to other departments. ✑ Each department will have one or more team leads who must have permissions to create and update tables and share these tables with their team members. ✑ Each department includes data analysts who require permissions to query the data, but should not have the ability to modify it.
How should you configure access to the data in BigQuery to meet these requirements?
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.
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.