Google Sample Question 25 of 27

You designed a data warehouse in BigQuery to analyze sales data. You want a self-serving, low-maintenance, and cost-effective solution to share the sales dataset to other business units in your organization. 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 Use the BigQuery Data Transfer Service to create a schedule that copies the sales dataset to the other business units’ projects.
B Create and share views with the users in the other business units.
C Create a BigQuery sharing (Analytics Hub) private exchange, and publish the sales dataset. ✓ Correct
D Enable the other business units’ projects to access the authorized views of the sales dataset.
🦉 Explanation by WiseOwl Tutor™ — not endorsed by Google

A is incorrect because while it is a working solution, it is not cost effective as it will increase the storage cost (copies) and expose partially stale data (12h) B is incorrect because a shared view does not give access to the data C is correct because it is cost effective, as the data is not copied and low maintenance as the data can be discovered and subscribed without additional involvement of the data producer. D is incorrect because while it works, the authorized views changes incur lots of maintenance, and reauthorizations from the dataset provider.

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™.