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.

View Answer

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