Answer-first summary for fast verification
Answer: 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.
The correct approach is to create a dataset for each department, assigning department leads the WRITER role to allow table creation and updates, and data analysts the READER role for querying without modification rights. This setup meets all specified requirements by ensuring data segregation and appropriate access levels. Other options either grant excessive permissions or fail to adequately segregate data by department.
Author: LeetQuiz Editorial Team
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.
No comments yet.