Google Professional Cloud Database Engineer Question 39
Select 3Google Cloud PlatformYou are managing a Cloud SQL instance running MySQL 5.7 and have been instructed to upgrade it to MySQL 8.0 to take advantage of new features. You need to plan the upgrade while minimizing downtime and ensuring data integrity. Which steps should you include in your upgrade plan?
- A
Create a backup of the database instance before starting the upgrade process.
- B
Perform a direct upgrade from MySQL 5.7 to MySQL 8.0 without assessing compatibility.
- C
Enable the maintenance window to automatically upgrade during the next scheduled period.
- D
Use the Cloud SQL upgrade feature to apply the upgrade after compatibility testing.
- E
Run the MySQL 8.0 Upgrade Checker tool to identify potential issues before upgrading.
Show answer and explanation
Correct answers: A, D, E
Explanation
Upgrading managed databases like Cloud SQL requires careful planning to ensure minimal downtime and data integrity. Creating a backup is essential for recovery in case of issues. Using the Cloud SQL upgrade feature is the supported approach for upgrades, and running tools like the MySQL 8.0 Upgrade Checker ensures that the database is ready for the upgrade. Skipping compatibility checks or relying solely on automated maintenance windows can lead to unexpected errors or downtime.
- A. Correct.
Creating a backup is a critical step to ensure data integrity in case the upgrade process encounters issues and a rollback is needed.
- B. Incorrect.
Performing a direct upgrade without assessing compatibility is risky and may lead to application issues or data corruption.
- C. Incorrect.
While enabling the maintenance window can automate upgrades, it does not allow for controlled testing, preparation, or issue identification before the upgrade.
- D. Correct.
Using the Cloud SQL upgrade feature is the recommended approach for upgrading managed databases, as it ensures a controlled and supported upgrade process.
- E. Correct.
Running the MySQL 8.0 Upgrade Checker tool helps identify incompatibilities or issues in the current MySQL 5.7 database that need to be addressed before upgrading.