Google Cloud Professional Data Engineer — Question 209

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?

Answer options

• A. Create an Analytics Hub private exchange, and publish the sales dataset.
• B. Enable the other business units’ projects to access the authorized views of the sales dataset.
• C. Create and share views with the users in the other business units.
• D. Use the BigQuery Data Transfer Service to create a schedule that copies the sales dataset to the other business units’ projects.

Correct answer: A

Explanation

Creating an Analytics Hub private exchange and publishing the sales dataset allows for a centralized, self-service model that minimizes maintenance while efficiently sharing data across business units. The other options, such as enabling access to authorized views or creating and sharing views, do not provide the same level of ease and scalability for sharing datasets across multiple units. Using the BigQuery Data Transfer Service is also less efficient as it creates copies rather than enabling shared access.