Examkin

Soru

Zorluk: OrtaDesigning Migration Plans and Data Transfer Strategies

A genomic research organization needs to migrate an on-premises data archive of 65 TB65\text{ TB} of uncompressed sequence files and an operational 400 GB400\text{ GB} PostgreSQL database to Google Cloud. The organization has an operational 1 Gbps1\text{ Gbps} Dedicated Interconnect with 600 Mbps600\text{ Mbps} of unallocated bandwidth dedicated to migration tasks. The business requirement dictates a maximum database cutover downtime of 2 hours2\text{ hours}. Which data transfer and database migration strategy should the cloud architect recommend?

  1. A
    Order a Google Cloud Transfer Appliance to transfer the 65 TB65\text{ TB} archive offline, and perform a offline database dump and restore to Cloud SQL for PostgreSQL during the maintenance window.
  2. Use Storage Transfer Service over the Dedicated Interconnect to move the 65 TB65\text{ TB} archive, and use Database Migration Service (DMS) for continuous replication of the PostgreSQL database to Cloud SQL.Cevap
  3. C
    Use Storage Transfer Service to transfer the 65 TB65\text{ TB} archive, and migrate the PostgreSQL database to Cloud Spanner to ensure multi-region horizontal scalability during migration.
  4. D
    Set up multiple HA VPN tunnels over the public internet to transfer the 65 TB65\text{ TB} archive, and use Database Migration Service to migrate the database to Cloud SQL.

Cevap

Use Storage Transfer Service over the Dedicated Interconnect to move the archive data, and use Database Migration Service (DMS) with continuous replication for the PostgreSQL database migration to Cloud SQL.
Transferring 65 TB65\text{ TB} over an available 600 Mbps600\text{ Mbps} connection takes approximately 10 days online, making Storage Transfer Service over the existing Dedicated Interconnect the optimal choice without incurring physical device shipping delays. For the PostgreSQL database, Database Migration Service (DMS) provides continuous CDC replication to Cloud SQL, allowing the target instance to sync continuously until a quick cutover is performed within the 2-hour downtime window.

Adım Adım Çözüm

1
Calculate data transfer time for the unstructured archive online vs offline
Transferring 65 TB65\text{ TB} (520,000 Gbits520,000\text{ Gbits}) at 600 Mbps600\text{ Mbps} takes 520,0000.6≈866,667 seconds≈10 days\frac{520,000}{0.6} \approx 866,667\text{ seconds} \approx 10\text{ days}.
Because 10 days is well within standard online migration planning windows, an online transfer via Storage Transfer Service over the existing Dedicated Interconnect avoids physical appliance logistics.
2
Select the database migration tool based on downtime constraints
Database Migration Service (DMS) enables continuous change data capture (CDC) replication from on-premises PostgreSQL to Cloud SQL for PostgreSQL.
Continuous replication allows the target Cloud SQL database to remain synchronized, enabling cutover in minutes and staying strictly within the 2-hour downtime requirement.

Anahtar Kavram

Selecting GCP data transfer and database migration tools based on network bandwidth calculations, dataset scale, and downtime windows.
Bu soruyu puanla

Konular

Designing Migration Plans and Data Transfer Strategies