Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
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.
B
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.
C
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.
D
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.
