Topic 1 Question 118
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?
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.
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.
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.
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.
ユーザの投票
コメント(17)
- 正解だと思う選択肢: B
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.
👍 6AWSandeep2022/09/03 Vote D, there is only Viewer, Editor and Owner roles for BQ https://cloud.google.com/bigquery/docs/access-control-basic-roles
👍 5nwk2022/09/05Ans.B Leads needs to create tables, meaning they need a dataset and analysts only need read permissions
👍 3damaldon2022/09/02
シャッフルモード