Answer-first summary for fast verification
Answer: Give analysts the BigQuery Data Viewer role on the shared dataset. Create a dataset for each analyst, and give each analyst the BigQuery Data Editor role at the dataset level for their assigned dataset.
The correct answer is C. By giving analysts the BigQuery Data Viewer role on the shared dataset, you ensure they can read but not modify the data, meeting the requirement of making the data readable but unmodifiable. Creating a dataset for each analyst and assigning them the BigQuery Data Editor role at the dataset level for their assigned dataset allows them to create and store tables for their own use within their individual workspaces, inaccessible by others, fulfilling the requirement of providing individual workspaces. Options A and D do not provide individual workspaces for analysts, as all analysts would have access to the same dataset or each other's tables, respectively. Option B does not offer individual workspaces, as all analysts would have access to the same shared and additional dataset, failing to isolate tables for each analyst.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To centralize your team's shared tables in a single dataset for convenient access by different analysts while ensuring the data is viewable but not editable, and to grant analysts separate workspaces within the project for personal use, ensuring privacy from other team members, what steps should you take?
A
Give analysts the BigQuery Data Viewer role at the project level. Create one other dataset, and give the analysts the BigQuery Data Editor role on that dataset.
B
Give analysts the BigQuery Data Viewer role on the shared dataset. Create one other dataset and give the analysts the BigQuery Data Editor role on that dataset.
C
Give analysts the BigQuery Data Viewer role on the shared dataset. Create a dataset for each analyst, and give each analyst the BigQuery Data Editor role at the dataset level for their assigned dataset.
D
Give analysts the BigQuery Data Viewer role at the project level. Create a dataset for each analyst, and give each analyst the BigQuery Data Editor role at the project level.
No comments yet.