How can you implement a security framework in BigQuery to restrict employees' access to only their department's travel and expense data within the "Master" dataset, while minimizing the number of configuration steps?

Exam-Like

Create a separate dataset for each department. Create a view with an appropriate WHERE clause to select records from a particular dataset for the specific department. Authorize this view to access records from your Master dataset. Give employees the permission to this department-specific dataset.

5.3%

Create a separate dataset for each department. Create a data pipeline for each department to copy appropriate information from the Master dataset to the specific dataset for the department. Give employees the permission to this department-specific dataset.

10.5%

Create a dataset named Master dataset. Create a separate view for each department in the Master dataset. Give employees access to the specific view for their department.

78.9%

Create a dataset named Master dataset. Create a separate table for each department in the Master dataset. Give employees access to the specific table for their department.

5.3%

Google Professional Cloud Developer

Get started today

Comments

How can you implement a security framework in BigQuery to restrict employees' access to only their department's travel and expense data within the "Master" dataset, while minimizing the number of configuration steps?