Ultimate access to all questions.
You are responsible for configuring BigQuery access for different departments within your company, with specific requirements: each department should only access their own data, department leads should be able to create and update tables for their team, and data analysts should only query data without modification rights. How would you set up BigQuery access to meet these needs?