Google Cloud Professional Data Engineer — Question 200

You want to store your team’s shared tables in a single dataset to make data easily accessible to various analysts. You want to make this data readable but unmodifiable by analysts. At the same time, you want to provide the analysts with individual workspaces in the same project, where they can create and store tables for their own use, without the tables being accessible by other analysts. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as it allows analysts to view the shared dataset while ensuring they can only edit their own datasets, maintaining data integrity. Option A is incorrect because it does not provide individual datasets for each analyst. Option B fails to isolate the analysts' workspaces, as it assigns the editor role at the project level. Option D does not provide individual datasets for each analyst, which is necessary for privacy and control over their own tables.