You are a database administrator managing sales transaction data by region stored in a BigQuery table. You need to ensure that each sales representative can only see the transactions in their region. What should you do?
A.
Add a policy tag in BigQuery.
B.
Create a row-level access policy.
C.
Create a data masking rule.
D.
Grant the appropriate IAM permissions on the dataset.
The best option is B. Row-level access policy. Option B is best because row-level policies directly filter data by region for each rep. Option A (Policy tag) is incorrect because tags are for column-level control, not rows. Option C (Data masking) is incorrect because masking hides data, doesn't filter rows. Option D (IAM permissions) is incorrect because IAM controls dataset/table access, not row-level. Therefore, Option B, row-level policies, is the correct way to restrict data by region.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
n2183712847
1 month, 4 weeks ago