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 1AM permissions on the dataset.
Creating arow-level access policyin BigQuery ensures that each sales representative can see only the transactions relevant to their region. Row-level access policies allow you to define fine-grained access control by filtering rows based on specific conditions, such as matching the sales representative's region. This approach enforces security while providing tailored data access, aligning with the principle of least privilege.
Extract from Google Documentation: From "Row-Level Security in BigQuery" (https://cloud.google.com/bigquery/docs/row-level-security ):"Row-level access policies let you restrict access to specific rows in a table based on a filter condition, such as a user’s region, providing fine-grained control over data visibility without creating separate tables or views."
[: Google Cloud Documentation - "BigQuery Row-Level Security" (https://cloud.google.com/bigquery/docs/row-level-security)., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit