Crucial Exams

GCP Professional Data Engineer Practice Question

A healthcare provider must migrate a 50 TB on-premises MySQL database to Cloud SQL for MySQL using Database Migration Service (DMS). The migration has two non-negotiable requirements:

  • Continuous data replication is needed to keep cut-over time under 5 minutes.
  • Patient-data traffic must stay off the public internet and sustain at least 10 Gbps throughput during the bulk-load phase.

Which network connectivity approach best satisfies these constraints while keeping operational overhead low?

  • Provision a Dedicated Cloud Interconnect to the Google Cloud VPC and configure DMS to use private connectivity over the Interconnect link.

  • Run DMS over standard internet links using public IP connectivity and protect traffic with SSL/TLS during transit.

  • Export the database to encrypted dump files, transfer them with Transfer Appliance to Cloud Storage, then import into Cloud SQL after shipment.

  • Establish an HA Cloud VPN tunnel and configure DMS to use public IP connectivity with source IP allow-listing.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot