Question 167 of 307
Single answerYou 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?
✓AAssign the users/groups data viewer access at the table level for each table
BCreate 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
CCreate 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
DCreate 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
Assign the users/groups data viewer access at the table level for each table
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.