New Year Sale 2026! 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 2 Question 10 Discussion

Actual exam question for Google's Associate Data Practitioner exam
Question #: 10
Topic #: 2
[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.


by Thersa at Apr 08, 2025, 11:58 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
Karina
2 months ago
I thought data masking would work for this?
upvoted 0 times
...
Merilyn
3 months ago
A policy tag won't restrict visibility like that.
upvoted 0 times
...
Samira
3 months ago
Wait, can you really limit access by region with just IAM permissions?
upvoted 0 times
...
Dean
3 months ago
100% agree with B, it's the best option here!
upvoted 0 times
...
Alex
3 months ago
Definitely B, row-level access is the way to go!
upvoted 0 times
...
Kattie
4 months ago
Granting IAM permissions seems too broad for this scenario; we need something more specific to the data visibility by region.
upvoted 0 times
...
Katlyn
4 months ago
I practiced a similar question where we had to limit access to certain rows, and I think the answer was definitely about row-level access policies.
upvoted 0 times
...
Herman
4 months ago
I'm not entirely sure, but I feel like policy tags might be more about categorizing data rather than controlling access.
upvoted 0 times
...
Danica
4 months ago
I think I remember something about row-level access policies being used for restricting data visibility based on user attributes.
upvoted 0 times
...
Jackie
5 months ago
I'm a bit confused by the options presented. Adding a policy tag and creating a data masking rule don't seem directly relevant to the problem statement. I'll need to review the BigQuery documentation to understand the differences between the options.
upvoted 0 times
...
Selma
5 months ago
Okay, let's see. The key here is ensuring each sales rep can only see the transactions in their region. I think creating a row-level access policy would be the best approach to achieve that granular control.
upvoted 0 times
...
Frank
5 months ago
Hmm, I'm not entirely sure about this one. I know BigQuery has some access control features, but I'm not familiar with the specific options mentioned in the question. I'll need to think this through carefully.
upvoted 0 times
...
Maddie
5 months ago
This seems like a straightforward question about managing access to data in BigQuery. I'm pretty confident I can figure this out.
upvoted 0 times
...
Eleni
10 months ago
Data masking? Really? That's like trying to hide the elephant in the room. B is definitely the way to go here.
upvoted 0 times
Wilda
8 months ago
User 4: Granting the appropriate 1AM permissions on the dataset is crucial.
upvoted 0 times
...
Mabelle
8 months ago
User 3: Adding a policy tag in BigQuery might also work.
upvoted 0 times
...
Troy
8 months ago
User 2: I agree, creating a row-level access policy is the best option.
upvoted 0 times
...
Hyun
9 months ago
User 1: Data masking is not the way to go.
upvoted 0 times
...
...
Ardella
10 months ago
Haha, who needs row-level access when you can just add a policy tag? That's the easiest way to manage this, right? *wink*
upvoted 0 times
Alona
8 months ago
User 3: Creating a row-level access policy could work too, but a policy tag seems simpler.
upvoted 0 times
...
Johnna
8 months ago
User 2: I agree, it's the easiest way to manage access for sales representatives by region.
upvoted 0 times
...
Christiane
9 months ago
User 1: Yeah, adding a policy tag in BigQuery is definitely the way to go.
upvoted 0 times
...
...
Melynda
10 months ago
Option D seems like the way to go. Grant the appropriate IAM permissions on the dataset and you're all set.
upvoted 0 times
Vilma
9 months ago
Adding a policy tag in BigQuery could also help in restricting access to specific regions.
upvoted 0 times
...
Pauline
9 months ago
I think creating a row-level access policy would be more secure and efficient.
upvoted 0 times
...
Susana
10 months ago
Option D seems like the way to go. Grant the appropriate IAM permissions on the dataset and you're all set.
upvoted 0 times
...
...
Marleen
10 months ago
I think the correct answer is B. Creating a row-level access policy makes the most sense for ensuring that each sales rep can only see the transactions in their region.
upvoted 0 times
...
Salina
11 months ago
I'm not sure, but I think D) Grant the appropriate IAM permissions on the dataset could also work to restrict access.
upvoted 0 times
...
Leota
11 months ago
I agree with Marta. By creating a row-level access policy, we can restrict access to specific rows based on the sales representative's region.
upvoted 0 times
...
Marta
11 months ago
I think the answer is B) Create a row-level access policy.
upvoted 0 times
...

Save Cancel