Google Professional Cloud Database Engineer Question 222
Select 4Google Cloud PlatformYour company is migrating a MySQL database hosted on-premises to Cloud SQL for MySQL on Google Cloud. The database has a large amount of data and is critical to business operations. You need to plan the migration to minimize downtime and data loss. Which steps should you include in your migration plan?
- A
Use the Database Migration Service (DMS) to handle both schema conversion and data migration.
- B
Perform a schema conversion manually or with a tool, and validate compatibility with Cloud SQL.
- C
Set up continuous replication from the source database to Cloud SQL using DMS.
- D
Test the migration process on a staging environment before migrating the production database.
- E
Schedule a fallback plan to restore the on-premises database in case of migration failure.
Show answer and explanation
Correct answers: B, C, D, E
Explanation
Migrating a database to Cloud SQL requires careful planning to ensure minimal downtime and data loss. Schema conversion is necessary to ensure compatibility, and continuous replication helps keep the target database in sync with the source. Testing the migration in a staging environment reduces risks, and a fallback plan provides a safety net in case of unexpected issues. Database Migration Service (DMS) is a valuable tool for data migration but does not handle schema conversion, so both aspects need to be addressed separately.
- A. Incorrect.
Incorrect: Database Migration Service (DMS) can handle data migration and replication, but it does not perform schema conversion. Schema conversion must be done manually or with a separate tool.
- B. Correct.
Correct: Schema conversion ensures that the database schema is compatible with Cloud SQL. Validating the schema is a critical step before data migration.
- C. Correct.
Correct: Setting up continuous replication minimizes downtime by keeping the target database updated with changes made to the source database during migration.
- D. Correct.
Correct: Testing the migration process in a staging environment helps identify and resolve issues before the production migration, reducing the risk of failure.
- E. Correct.
Correct: A fallback plan ensures that the source database can be restored and operational in case the migration fails, minimizing business disruption.