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 Exam Associate Data Practitioner 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:

Submit Cancel
Eleni
16 days 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
...
Ardella
18 days 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
...
Melynda
1 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
Pauline
3 days ago
I think creating a row-level access policy would be more secure and efficient.
upvoted 0 times
...
Susana
19 days 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
1 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
1 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
2 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
2 months ago
I think the answer is B) Create a row-level access policy.
upvoted 0 times
...

Save Cancel