Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the most effective method to manage user permissions in a BigQuery data warehouse for multiple teams, ensuring each team only accesses specific tables based on their team membership?
A
Create authorized views for each team in datasets created for each team. Grant data viewer access to the authorized views for the dataset where the data resides, and grant data viewer access to the datasets where the authorized views reside for the users/groups.
B
Grant data viewer access to the users/groups at the table level for each table.
C
Create SQL views for each team in the same dataset as the data and grant data viewer access to the SQL views for the users/groups.
D
Create authorized views for each team in the same dataset as the data and grant data viewer access to the authorized views for the users/groups.
