To give a user read permission for only the first three columns of a table, which access control method would you use?

The correct answer is C. Authorized view. Explanation/Reference: 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…

Submitted by tyler.j· Mar 30, 2026Designing data processing systems

Question

To give a user read permission for only the first three columns of a table, which access control method would you use?

Options

APrimitive role
BPredefined role
CAuthorized view
DIt's not possible to give access to only the first three columns of a table.

How the community answered

(29 responses)

A
17% (5)
B
3% (1)
C
72% (21)
D
7% (2)

Explanation

Explanation/Reference: 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.

Topics

#authorized views#column-level security#BigQuery access control#IAM

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice