GCP Professional Cloud Architect Practice Question
Your team is preparing a detailed runbook for migrating a mission-critical 10 TB on-premises PostgreSQL database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The runbook is divided into discovery/assessment, planning, and execution sections. Which of the following tasks belongs in the planning section rather than in discovery/assessment or execution?
Document a rollback plan and the precise order in which client applications will be cut over to Cloud SQL.
Inventory all database schemas and collect baseline CPU, I/O, and query-latency statistics from the source instance.
Execute user-acceptance and performance tests against the Cloud SQL instance to confirm it meets the agreed service level objective.
Start a DMS continuous-data-replication job and monitor lag until scheduled cutover time.
During planning you translate the findings from discovery into a concrete, risk-mitigated migration design. Defining an explicit rollback strategy and cutover sequencing is part of that design work: it uses the inventory and performance data gathered in discovery and is required before you launch DMS jobs or validation tests in execution. Cataloging schemas and measuring utilization are discovery tasks, while starting DMS continuous replication and running post-migration performance tests are execution-phase activities.
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 the role of a rollback plan in database migration?
Open an interactive chat with Bash
How does Database Migration Service (DMS) use continuous replication in migration?
Open an interactive chat with Bash
What is included in performance tests during a database migration?
Open an interactive chat with Bash
What is the purpose of a rollback plan during database migration?
Open an interactive chat with Bash
How does the planning phase differ from discovery and execution in migration projects?
Open an interactive chat with Bash
What is the role of Database Migration Service (DMS) during database migration to Cloud SQL?
Open an interactive chat with Bash
GCP Professional Cloud Architect
Managing implementation
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 .