Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are responsible for configuring BigQuery access for different departments within your company, with specific requirements: each department should only access their own data, department leads should be able to create and update tables for their team, and data analysts should only query data without modification rights. How would you set up BigQuery access to meet these needs?
A
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.
B
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.
C
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.
D
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.