Exam Associate Data Practitioner topic 1 question 69 discussion

The best option is A. Use authorized views. Option A is best because authorized views are the simplest and most secure way to share query results (aggregated data) without granting access to underlying sensitive data. The payroll specialist only sees the view, not the raw data. Option B (Row/column permissions) is incorrect because it's more complex to set up and manage than authorized views, and might still grant access to the sensitive table, just with restrictions. Option C (New aggregated table) is incorrect because creating a new table adds unnecessary data duplication and management overhead compared to views. Option D (Export to Cloud Storage) is incorrect because it's the most complex and least secure - exporting data creates copies and sharing a bucket is less controlled than BigQuery access controls. Therefore, Option A, authorized views, is the simplest and most secure approach for this scenario.

Creating a separate table duplicates data and introduces potential data consistency issues. Authorized views provide a more dynamic and maintainable solution.

The best approach is C. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.