A healthcare startup plans to migrate its legacy on-premises architecture to Google Cloud. The environment consists of a PostgreSQL transactional database and of unstructured medical imaging files stored on an SMB file share. The company has a dedicated network connection to GCP. The migration strategy must ensure minimal downtime for the database and direct online ingestion of the image files into Cloud Storage with automated integrity verification. Which TWO architectural solutions should be included in the migration design? (Select TWO.)
- Use Database Migration Service (DMS) with continuous CDC replication to migrate the PostgreSQL database to Cloud SQL.Answer
- Use Storage Transfer Service for on-premises data transfer to migrate the medical image files directly into Cloud Storage.Answer
- CRequest a GCP Transfer Appliance to physically transport the 15 TB PostgreSQL database to avoid consuming bandwidth.
- DMigrate the PostgreSQL database directly to Cloud Spanner using standard pg_dump files to simplify transaction scaling.
Answer
The strategy should incorporate Database Migration Service (DMS) with continuous CDC for the PostgreSQL database and Storage Transfer Service for moving the file share data to Cloud Storage over the available network link.
The correct strategy combines Database Migration Service (DMS) for continuous CDC replication of the PostgreSQL database to Cloud SQL with Storage Transfer Service for streaming on-premises file share data to Cloud Storage. This design meets the requirements of minimal database downtime and online file migration over the 1 Gbps link.
Step-by-Step Solution
Key Concept
Selecting optimal online migration services (DMS and Storage Transfer Service) based on dataset scale, minimal downtime requirements, and network throughput.