Google Cloud Associate Data Practitioner — Question 67

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?

Answer options

• 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.

Correct answer: B

Explanation

Creating a row-level access policy is the correct approach as it allows you to control access to specific rows based on the user's attributes, ensuring that each representative views only their transactions. The other options do not provide the necessary granularity for restricting visibility to specific rows within the dataset.