Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 30 of 108
Free Preview · 108 of 359 · questions 1–108 of 359 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
A is correct. with common view users should have acces to source tables but with authorized view they do not.
I think that "A" is the best solution, "C" could be too but the dataset Master already exists.
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. This option is the most straightforward and requires the fewest steps to implement row-level security in BigQuery. By creating a view for each department with an appropriate WHERE clause that filters records based on the department, you can ensure that employees only see data that's relevant to them. The views act as a secure interface to the underlying data. You then grant each employee access to the view of their respective department. This method minimizes the number of datasets and tables you have to manage and leverages BigQuery's built-in access control mechanisms.