Google Cloud Professional Data Engineer PDE — Topic 1 Question 118

Question

You need to set access to BigQuery for different departments within your company. Your solution should comply with the following requirements: • Each department should have access only to their data. • Each department will have one or more leads who need to be able to create and update tables and provide them to their team. • Each department has data analysts who need to be able to query but not modify data. How should you set access to the data in BigQuery?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Create a dataset for each department. Assign the department leads the role of WRITER, and assign the data analysts the role of READER on their dataset.

Google Cloud Professional Data Engineer PDE — Question 118