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: 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. This ensures that analysts can read but not modify the shared dataset and have their own private workspaces where they can create and store their tables without being accessible by other analysts. This approach effectively balances accessibility and privacy for the datasets.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your team needs a strategy to store shared tables within a single dataset to ensure data accessibility for various analysts. This data should be readable but not modifiable by the analysts. Additionally, each analyst requires a personal workspace within the same project to create and store their own tables, while ensuring these individual tables remain inaccessible to other analysts. What steps should you take to achieve this setup?
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 at the project level. Create a dataset for each analyst, and give each analyst the BigQuery Data Editor role at the project level.
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 on the shared dataset. Create one other dataset and give the analysts the BigQuery Data Editor role on that dataset.
No comments yet.