Google Professional Data Engineer
Comments
Loading comments...
Ultimate access to all questions.
You are in the process of migrating your data warehouse to Google BigQuery, a scalable, fully-managed data warehouse service on the Google Cloud Platform. You have successfully transferred all your data into various tables within a specific dataset in BigQuery. Multiple teams across your organization will need to access and use this data. However, to comply with data governance policies, each team should only have access to certain tables that are relevant to their roles and responsibilities. How should you configure user permissions in BigQuery to ensure that team members see only the tables they are authorized to view based on their team membership?
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