Google Professional Data Engineer Question 51
Select 3Google Cloud PlatformYou are tasked with migrating an on-premises MySQL database to Google Cloud. The database is mission-critical, and minimal downtime is required during the migration. You also need to ensure data consistency and avoid data corruption. Which of the following steps should you include in your migration plan?
- A
Use Database Migration Service (DMS) to set up continuous replication between the source and destination databases.
- B
Perform a full database dump from the on-premises database and import it into Cloud SQL during a scheduled downtime window.
- C
Enable a maintenance window in Cloud SQL to shut down the database during the migration process.
- D
Test the migration process in a staging environment before performing the actual migration.
- E
Configure network and firewall rules to allow secure communication between the on-premises database and Google Cloud.
Show answer and explanation
Correct answers: A, D, E
Explanation
To design a data migration plan with minimal downtime and data consistency, it is critical to use tools like Database Migration Service for continuous replication, validate the process in a staging environment, and secure network communication. These steps collectively ensure a reliable and secure migration process while meeting the requirements for minimal downtime.
- A. Correct.
Using Database Migration Service (DMS) with continuous replication ensures minimal downtime and data consistency as it allows for live replication of changes from the source to the destination database.
- B. Incorrect.
Performing a full database dump and import can lead to significant downtime, which contradicts the requirement of minimal downtime in the migration process.
- C. Incorrect.
Shutting down the database during migration is not necessary when using continuous replication or a phased migration approach, and it would result in unnecessary downtime.
- D. Correct.
Testing the migration process in a staging environment helps identify potential issues and validate the migration plan, ensuring a smooth transition during the actual migration.
- E. Correct.
Configuring network and firewall rules is essential for secure communication between the on-premises database and Google Cloud, preventing unauthorized access and ensuring data security.