GCP Professional Cloud Architect Practice Question
Your team will migrate a 15-TB on-premises MySQL database to Cloud SQL for MySQL by using Database Migration Service (DMS). Management asks for a proof of concept (POC) that validates the approach and produces a data-driven downtime estimate for the final cut-over. Which single action is essential to include in the POC so that you can derive an accurate downtime number?
Review the project's DMS connection quotas and network-egress limits to confirm they remain within published thresholds.
Continuously monitor and record replication-lag metrics during the DMS continuous-migration job until the lag stabilises near zero.
Run synthetic workload scripts against an empty Cloud SQL instance to measure query latency under load.
Export the entire on-premises database to Cloud Storage, import it into Cloud SQL, and time the file transfer and import steps.
To estimate cut-over downtime you must understand how quickly the target instance can catch up to the source after the initial bulk load. Monitoring replication-lag metrics while a DMS continuous-migration job is running provides that information. Synthetic benchmarks, offline exports, or quota reviews do not surface real-time replication behaviour, so they cannot yield an empirical downtime figure.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is replication lag in database migration?
Open an interactive chat with Bash
How does DMS help in continuous MySQL database migration?
Open an interactive chat with Bash
Why is Cloud SQL for MySQL a good target for migrating an on-premises database?
Open an interactive chat with Bash
What is replication lag in a database migration context?
Open an interactive chat with Bash
How does Database Migration Service (DMS) handle large-scale migrations like a 15-TB database?
Open an interactive chat with Bash
Why is monitoring replication lag important for estimating cut-over downtime?
Open an interactive chat with Bash
GCP Professional Cloud Architect
Analyzing and optimizing technical and business processes
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .