Topic 1 Question 149
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?
Assign the users/groups data viewer access at the table level for each table
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
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
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
ユーザの投票
コメント(17)
Correct A: A . Now it is feasible to provide table level access to user by allowing user to query single table and no other table will be visible to user in same dataset.
👍 37someshsehgal2021/02/08D should be the answer
👍 23madhu11712020/03/15I would go with D. Though A seems to be feasible, there could be numerous tables under a dataset, and to provide access to the users could be a cumbersome process. Instead, create datasets for multiple groups(so-called teams), and assign access policies to them.
👍 3kishanu2021/12/27
シャッフルモード