To give a user read permission for only the first three columns of a table, which access control method would you use?
To give a user read permission for only the first three columns of a table, which access control method would you use?
A . Primitive role
B . Predefined role
C . Authorized view
D . It’s not possible to give access to only the first three columns of a table.
Answer: C
Explanation:
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
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund