Crucial Exams

GCP Professional Cloud Architect Practice Question

Your company must move a 3-TB on-premises MySQL 5.7 database to Google Cloud SQL. The CIO demands less than 5 minutes of cut-over downtime and wants to avoid hosting any migration worker VMs. Security requires that the source database remain behind the corporate firewall and that all traffic traverse a private network path rather than the public internet. Which approach best satisfies all requirements?

  • Deploy a Compute Engine VM running gh-ost to replicate changes from the source MySQL to Cloud SQL over a Cloud VPN tunnel, then stop writes and promote the target.

  • Provision Database Transfer Service to copy tables to BigQuery, then use the BigQuery migration appliance to write the data back into Cloud SQL when ready for cut-over.

  • Use Database Migration Service with continuous replication and VPC peering connectivity to migrate the database to Cloud SQL, then perform a controlled cut-over when replication lag is under five minutes.

  • Export the data with mysqldump, upload the dump file to Cloud Storage, and run gcloud sql import sql to load it into a new Cloud SQL instance during a planned maintenance window.

GCP Professional Cloud Architect
Managing implementation
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