Google Sample Question 17 of 27

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?

Source: Google Cloud OFFICIAL

Official sample question published by Google Cloud. WiseOwlLearns is not affiliated with Google LLC.

All explanations and Option Analyzer™ content are generated by WiseOwlLearns and are not endorsed by Google Cloud.

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. ✓ Correct
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.
🦉 Explanation by WiseOwl Tutor™ — not endorsed by Google

There are three conditions that must be correct - 1) BigQuery Data Viewer permission should be at dataset level, not project level, so that analysts can't read others’ datasets. 2) Should have one dataset per analysts so that access to those tables can be restricted. 3) BigQuery Editor role should be granted at dataset level for each analyst to restrict access to just their assigned user. A is not correct because…Condition 1 wrong, 2 wrong, 3 right. B is not correct because…Condition 1 wrong, 2 right, 3 wrong. C is correct because…Condition 1 right, 2 right, 3 right. D is not correct because...Condition 1 right, 2 wrong, 3 right.

Ready to practice?

These 27 official sample questions are free to practice on WiseOwlLearns — no account required. Get real-time tutoring from WiseOwl Tutor™ and step-by-step elimination reasoning from Option Analyzer™.