PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #9
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #9: Real Exam Question with Answer & Explanation
The correct answer is A: Use Database Migration Service to migrate the databases to Cloud SQL.. https://cloud.google.com/sql/docs/mysql/replication/manage-replicas#basic-steps-to-change- parallel-replication-flags
Question
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
Options
- AUse Database Migration Service to migrate the databases to Cloud SQL.
- BUse a cross-region read replica to migrate the databases to Cloud SQL.
- CUse replication from an external server to migrate the databases to Cloud SQL.
- DUse an external read replica to migrate the databases to Cloud SQL.
- EUse a read replica to migrate the databases to Cloud SQL.
Explanation
https://cloud.google.com/sql/docs/mysql/replication/manage-replicas#basic-steps-to-change- parallel-replication-flags
Topics
Community Discussion
No community discussion yet for this question.