PROFESSIONAL-DATA-ENGINEER · Question #201
PROFESSIONAL-DATA-ENGINEER Question #201: Real Exam Question with Answer & Explanation
The correct answer is 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.. Explanation/Reference: https://cloud.google.com/bigquery/docs/access-control-primitive-roles#dataset-primitive-roles
Question
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?
Options
- ACreate 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.
- BCreate 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.
- CCreate 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.
- DCreate 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.
Explanation
Explanation/Reference: https://cloud.google.com/bigquery/docs/access-control-primitive-roles#dataset-primitive-roles
Community Discussion
No community discussion yet for this question.