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?

AAdd a policy tag in BigQuery.

BCreate a row-level access policy.

CCreate a data masking rule.

DGrant the appropriate 1AM permissions on the dataset.

Show Suggested 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

Marta

3 days ago

I think the answer is B) Create a row-level access policy.

upvoted 0 times

...