Topic 2 Question 11
To give a user read permission for only the first three columns of a table, which access control method would you use?
Primitive role
Predefined role
Authorized view
It's not possible to give access to only the first three columns of a table.
解説
An authorized view allows you to share query results with particular users and groups without giving them read access to the underlying tables. Authorized views can only be created in a dataset that does not contain the tables queried by the view. When you create an authorized view, you use the view's SQL query to restrict access to only the rows and columns you want the users to see. Reference: https://cloud.google.com/bigquery/docs/views#authorized-views
ユーザの投票
コメント(13)
Answer : C
👍 12[Removed]2020/03/21Answer: C Description: Authorized views are used to provided restricted access
👍 4[Removed]2020/03/28A: Column level security is possible now in BigQuery https://cloud.google.com/bigquery/docs/column-level-security-intro
👍 4Anweee2021/11/07
シャッフルモード