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