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?
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™.