Exam Associate-Data-Practitioner Topic 1 Question 25 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 25
Topic #: 1

Your organization has a BigQuery dataset that contains sensitive employee information such as salaries and performance reviews. The payroll specialist in the HR department needs to have continuous access to aggregated performance data, but they do not need continuous access to other sensitive dat a. You need to grant the payroll specialist access to the performance data without granting them access to the entire dataset using the simplest and most secure approach. What should you do?

A. Use authorized views to share query results with the payroll specialist. B. Create row-level and column-level permissions and policies on the table that contains performance data in the dataset. Provide the payroll specialist with the appropriate permission set. C. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist. D. Create a SQL query with the aggregated performance data. Export the results to an Avro file in a Cloud Storage bucket. Share the bucket with the payroll specialist.

Suggested Answer: A Vote an answer

Using authorized views is the simplest and most secure way to grant the payroll specialist access to aggregated performance data without exposing the entire dataset. Authorized views allow you to create a view in BigQuery that contains only the query results for the aggregated performance data. The payroll specialist can query the view without being granted access to the underlying sensitive data. This approach ensures security, adheres to the principle of least privilege, and eliminates the need to manage complex row-level or column-level permissions.

by Franklin at Mar 06, 2026, 11:20 PM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business