Examkin

Question

Difficulty: MediumDesigning Migration Plans and Data Transfer Strategies

A multinational logistics company plans to migrate its legacy logistics infrastructure to Google Cloud within a strict 3-week cutover window. The workload consists of a 500 TB500\text{ TB} unencrypted historical shipment tracking log archive and a 2 TB2\text{ TB} operational PostgreSQL database. The on-premises facility connects to the internet via a dedicated 100 Mbps100\text{ Mbps} network link. The solution must minimize operational downtime for the transactional workload while meeting the migration deadline. Which TWO migration and data transfer strategies should the cloud architect recommend?

  1. Order a Google Cloud Transfer Appliance to securely transfer the 500 TB500\text{ TB} archival dataset offline into Cloud Storage.Answer
  2. B
    Use Storage Transfer Service to stream the 500 TB500\text{ TB} archival dataset directly over the existing 100 Mbps100\text{ Mbps} network uplink into a Cloud Storage bucket.
  3. Use Database Migration Service (DMS) with continuous replication to migrate the 2 TB2\text{ TB} operational PostgreSQL database to Cloud SQL for PostgreSQL.Answer
  4. D
    Provision a multi-region Cloud Spanner instance and migrate the 2 TB2\text{ TB} PostgreSQL database using custom export and import scripts.

Answer

The cloud architect should recommend ordering a Google Cloud Transfer Appliance for the 500 TB archival dataset and using Database Migration Service (DMS) with continuous replication for the 2 TB operational PostgreSQL database.
For the 500 TB500\text{ TB} archival dataset, network transfer over 100 Mbps100\text{ Mbps} is mathematically impractical within 3 weeks; using a Transfer Appliance allows physical offline shipment of data. For the 2 TB2\text{ TB} operational PostgreSQL database, Database Migration Service provides native continuous replication to Cloud SQL with minimal cutover downtime.

Step-by-Step Solution

1
Calculate network throughput for bulk archival transfer
Transferring 500 TB500\text{ TB} (4×1015 bits4 \times 10^{15}\text{ bits}) over a 100 Mbps100\text{ Mbps} network connection requires approximately 40,000,000 seconds40,000,000\text{ seconds} (over 460 days), which fails the 3-week constraint.
Offline transfer via Cloud Transfer Appliance is necessary to meet the 3-week deadline.
2
Evaluate database migration requirements for continuous availability
Database Migration Service (DMS) continuously replicates CDC (Change Data Capture) changes from on-premises PostgreSQL to Cloud SQL.
DMS ensures minimal downtime cutover for transactional database workloads.

Key Concept

Designing hybrid data transfer strategies based on dataset size, network bandwidth calculations, and database replication tools.
Rate this question

Topics

Designing Migration Plans and Data Transfer Strategies