Google Cloud Professional Data Engineer — Question 40

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables in a dataset. Multiple users from your organization will be using the data. They should only see certain tables based on their team membership. How should you set user permissions?

Answer options

• A. Assign the users/groups data viewer access at the table level for each table
• B. Create SQL views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the SQL views
• C. Create authorized views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the authorized views
• D. Create authorized views for each team in datasets created for each team. Assign the authorized views data viewer access to the dataset in which the data resides. Assign the users/groups data viewer access to the datasets in which the authorized views reside

Correct answer: A

Explanation

The correct answer is A because assigning data viewer access at the table level ensures that users can only view the specific tables they are authorized to access. Options B and C involve creating views, which may not be necessary if table-level access can be managed directly. Option D complicates the structure by requiring multiple datasets, which is not needed for this scenario.