nerdexam
Google

PROFESSIONAL-DATA-ENGINEER · Question #260

You are migrating your data warehouse to Google Cloud and decommissioning your on-premises data center. Because this is a priority for your company, you know that bandwidth will be made available…

The correct answer is C. gsutil for the migration; Pub/Sub and Dataflow for the real-time updates. Explanation/Reference: Use Gsutil when there is enough bandwidth to meet your project deadline for less than 1 TB of data. Storage Transfer Service is for much larger volumes for migration. Moreover, Cloud Data Fusion and Dataproc are not ideal for real-time updates. BigQuery…

Submitted by kev92· Mar 30, 2026Building and operationalizing data processing systems

Question

You are migrating your data warehouse to Google Cloud and decommissioning your on-premises data center. Because this is a priority for your company, you know that bandwidth will be made available for the initial data load to the cloud. The files being transferred are not large in number, but each file is 90 GB Additionally, you want your transactional systems to continually update the warehouse on Google Cloud in real time. What tools should you use to migrate the data and ensure that it continues to write to your warehouse?

Options

  • AStorage Transfer Service for the migration, Pub/Sub and Cloud Data Fusion for the real-time updates
  • BBigQuery Data Transfer Service for the migration, Pub/Sub and Dataproc for the real-time updates
  • Cgsutil for the migration; Pub/Sub and Dataflow for the real-time updates
  • Dgsutil for both the migration and the real-time updates

How the community answered

(35 responses)
  • A
    3% (1)
  • C
    94% (33)
  • D
    3% (1)

Explanation

Explanation/Reference: Use Gsutil when there is enough bandwidth to meet your project deadline for less than 1 TB of data. Storage Transfer Service is for much larger volumes for migration. Moreover, Cloud Data Fusion and Dataproc are not ideal for real-time updates. BigQuery Data Transfer Service does not support all on-prem sources. https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#gsutil_for_smaller_transfers_of_on-premises_data

Topics

#gsutil#Pub/Sub#Dataflow#data migration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PROFESSIONAL-DATA-ENGINEER Practice