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

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.


Contribute your Thoughts:

Salina
8 days 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
16 days 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
24 days ago
I think the answer is B) Create a row-level access policy.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77