Google
PROFESSIONAL-DATA-ENGINEER · Question #395
You are migrating your on-premises data warehouse to BigQuery. As part of the migration, you want to facilitate cross-team collaboration to get the most value out of the organization's data. You need
The correct answer is C. Use BigQuery Data Transfer Service to copy datasets to a centralized BigQuery project for sharing.. Explanation/Reference: To provide a cost-effective storage and processing solution that allows data scientists to explore data similarly to using the on-premises HDFS cluster with SQL on the Hive query engine, deploying a Dataproc cluster is the best choice.
Submitted by brentm· Mar 30, 2026Designing data processing systems
Question
You are migrating your on-premises data warehouse to BigQuery. As part of the migration, you want to facilitate cross-team collaboration to get the most value out of the organization's data. You need to design an architecture that would allow teams within the organization to securely publish, discover, and subscribe to read- only data in a self-service manner. You need to minimize costs while also maximizing data freshness. What should you do?
Options
- ACreate authorized datasets to publish shared data in the subscribing team's project.
- BCreate a new dataset for sharing in each individual team's project. Grant the subscribing team the bigquery dataViewer role on the dataset.
- CUse BigQuery Data Transfer Service to copy datasets to a centralized BigQuery project for sharing.
- DUse Analytics Hub to facilitate data sharing.
How the community answered
(36 responses)- A25% (9)
- B11% (4)
- C58% (21)
- D6% (2)
Explanation
Explanation/Reference: To provide a cost-effective storage and processing solution that allows data scientists to explore data similarly to using the on-premises HDFS cluster with SQL on the Hive query engine, deploying a Dataproc cluster is the best choice.
Topics
#Analytics Hub#data sharing#BigQuery#data mesh
Community Discussion
No community discussion yet for this question.