Câu 5: Associate Data Practitioner: Google Cloud Certified - Associate Data Practitioner

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 data. 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?

1. A. Use authorized views to share query results with the payroll specialist. — đáp án hiện tại
2. 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.
3. C. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.
4. 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.