Topic 1 Question 61
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?
Add a policy tag in BigQuery.
Create a row-level access policy.
Create a data masking rule.
Grant the appropriate IAM permissions on the dataset.
ユーザの投票
コメント(1)
- 正解だと思う選択肢: B
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.
👍 1n21837128472025/03/05
シャッフルモード