Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Data Practitioner Exam - Topic 4 Question 23 Discussion

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?
B) Create a row-level access policy.
A) Add a policy tag in BigQuery.
C) Create a data masking rule.
D) Grant the appropriate 1AM permissions on the dataset.

Google Associate Data Practitioner Exam - Topic 4 Question 23 Discussion

Actual exam question for Google's Associate Data Practitioner exam
Question #: 23
Topic #: 4
[All Associate Data Practitioner Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Creating a row-level access policy in 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.' Reference: Google Cloud Documentation - 'BigQuery Row-Level Security' (https://cloud.google.com/bigquery/docs/row-level-security).


by Jesse at Apr 11, 2026, 03:14 AM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Altha
4 days ago
Overall, B is the most secure option for this scenario.
upvoted 0 times
...
Xenia
9 days ago
C is not suitable here. Data masking doesn’t solve the region issue.
upvoted 0 times
...
Buddy
14 days ago
I feel D is too broad. IAM permissions alone won’t limit visibility.
upvoted 0 times
...
Vicki
19 days ago
A could work, but it’s not specific enough.
upvoted 0 times
...
Lenny
24 days ago
Agreed, B makes sense. It restricts data access effectively.
upvoted 0 times
...
Florencia
30 days ago
I think B is the best choice. Row-level access is crucial.
upvoted 0 times
...
Pearly
1 month ago
Wait, isn't IAM permissions enough for this?
upvoted 0 times
...
Marci
1 month ago
Definitely B, but can we really trust it to work as intended?
upvoted 0 times
...
Miesha
2 months ago
I thought data masking was enough, but I guess not!
upvoted 0 times
...
Olive
2 months ago
A policy tag won't restrict access like B does.
upvoted 0 times
...
Tammara
2 months ago
B is the way to go for row-level security!
upvoted 0 times
...
Halina
2 months ago
Wait, isn't IAM permissions enough for this?
upvoted 0 times
...
Janessa
2 months ago
Definitely B, but can we really trust it to work as intended?
upvoted 0 times
...
Eric
2 months ago
I thought data masking was enough, but I guess not!
upvoted 0 times
...
Lili
4 months ago
A policy tag won't restrict access like B does.
upvoted 0 times
...
Lachelle
4 months ago
B is the way to go for row-level security!
upvoted 0 times
...
Carline
5 months ago
Data masking rules sound familiar, but I don't think they would actually restrict access to the data based on regions.
upvoted 0 times
...
Lorean
5 months ago
I feel like we practiced a similar question where we had to limit access. I think it was about IAM permissions, but I'm not confident that's the best option here.
upvoted 0 times
...
Catina
5 months ago
I'm not entirely sure, but I remember something about policy tags. Could they help with this scenario?
upvoted 0 times
...
Trinidad
5 months ago
I think we discussed row-level access policies in class. They seem like the right choice for restricting data visibility by region.
upvoted 0 times
...

Save Cancel