Home › GCP Data Engineer › cloudcomputing › gcpdedesign › Which GCP service should a Data Engineer use to …
Which GCP service should a Data Engineer use to MIGRATE on-prem databases (Oracle/SQL Server/MySQL/Postgres) to Cloud SQL or AlloyDB with minimal downtime — referenced in PDE §1.4?
ABigQuery Data Transfer Service (for SaaS analytics imports)
BDatabase Migration Service
CCloud DNS
DCloud Memorystore
Answer & Solution
Correct answer: B. Database Migration Service
Database Migration Service migrates DBs to Cloud SQL/AlloyDB (per PDE §1.4). BigQuery DTS is for SaaS warehouse ingest; the others aren't migration tools.
Related questions
Which GCP service should a Data Engineer use to import data from SaaS sources (Salesforce,Which GCP service should a Data Engineer use to ship terabytes-to-petabytes of data OFFLINWhich GCP service should a Data Engineer use to STREAM change-data-capture (CDC) from OracWhich GCP service should a Data Engineer use as a managed, drag-and-drop, code-free data iWhich GCP service should a Data Engineer use as a managed Apache Spark + Hadoop cluster foWhich GCP service should a Data Engineer use as a managed Apache Beam runtime for unified Which GCP service should a Data Engineer use to prepare + clean structured data via SQL-baWhich GCP control should a Data Engineer use to enforce 'data must stay in europe-west reg