Google Sample Question 15 of 27

Different teams in your organization store customer and performance data in BigQuery. Each team needs to keep full control of their collected data, be able to query data within their projects, and be able to exchange their data with other teams. You need to implement an organization-wide solution, while minimizing operational tasks and costs. What should you do?

Source: Google Cloud OFFICIAL

Official sample question published by Google Cloud. WiseOwlLearns is not affiliated with Google LLC.

All explanations and Option Analyzer™ content are generated by WiseOwlLearns and are not endorsed by Google Cloud.

A Ask each team to create authorized views of their data. Grant the biquery.jobUser role to each team.
B Ask each team to publish their data in BigQuery sharing (Analytics Hub). Direct the other teams to subscribe to them. ✓ Correct
C Create a BigQuery scheduled query to replicate all customer data into team projects.
D Enable each team to create materialized views of the data they need to access in their projects.
🦉 Explanation by WiseOwl Tutor™ — not endorsed by Google

A Is not correct because biquery.jobUser does not grant access to data. Authorized views are not minimizing operational efforts needed. B Is correct because it automatically creates an authorized dataset at subscription time. C Is not correct because it is increasing costs (data duplication) and adding operational tasks. D Is not correct because it is increasing costs (data duplication) and adding operational tasks.

Ready to practice?

These 27 official sample questions are free to practice on WiseOwlLearns — no account required. Get real-time tutoring from WiseOwl Tutor™ and step-by-step elimination reasoning from Option Analyzer™.