Ultimate access to all questions.
You are tasked with configuring access permissions to BigQuery for various departments within your organization. The solution should adhere to these specific requirements:
✑ Each department must have exclusive access to their respective data and no access to data belonging to other departments. ✑ Each department will have one or more team leads who must have permissions to create and update tables and share these tables with their team members. ✑ Each department includes data analysts who require permissions to query the data, but should not have the ability to modify it.
How should you configure access to the data in BigQuery to meet these requirements?