
Ultimate access to all questions.
Different teams within your organization have their customer and performance data stored in BigQuery. Each team requires full control over their collected data, the ability to query data within their own projects, and also the capability to exchange their data with other teams when necessary. You need to devise and implement an organization-wide solution that facilitates these requirements, ensuring operational tasks and costs are kept to a minimum. What should you do?
A
Ask each team to create authorized views of their data. Grant the bigquery.jobUser role to each team.
B
Create a BigQuery scheduled query to replicate all customer data into team projects.
C
Ask each team to publish their data in Analytics Hub. Direct the other teams to subscribe to them.
D
Enable each team to create materialized views of the data they need to access in their projects.