Google Professional Cloud Database Engineer Question 38
Select 3Google Cloud PlatformYour team is managing a Cloud SQL database running MySQL 5.7, and you need to upgrade it to MySQL 8.0 for compatibility with a new application feature. The database serves critical production workloads, and downtime must be minimized. Which actions should you take to plan and perform the upgrade effectively?
- A
Create a backup of the database before initiating the upgrade.
- B
Perform the upgrade directly on the production instance to minimize effort.
- C
Review the MySQL 8.0 release notes and identify potential incompatibilities.
- D
Test the upgrade process and application behavior on a cloned instance.
- E
Disable automatic backups before starting the upgrade to avoid conflicts.
Show answer and explanation
Correct answers: A, C, D
Explanation
Upgrading a Cloud SQL instance requires careful planning to minimize downtime and ensure compatibility. Backups, testing on a cloned instance, and reviewing release notes are critical steps to identify risks and validate the process. Performing upgrades directly on production without testing or disabling backups exposes the system to unnecessary risks.
- A. Correct.
Creating a backup ensures you can restore the database if anything goes wrong during the upgrade, which is a best practice.
- B. Incorrect.
Performing the upgrade directly on the production instance increases the risk of downtime and potential data loss. Testing is required first.
- C. Correct.
Reviewing the release notes helps identify breaking changes or deprecated features that could impact the application.
- D. Correct.
Testing the upgrade process on a cloned instance allows you to validate both the upgrade and the application behavior without affecting production.
- E. Incorrect.
Disabling automatic backups is not recommended as it can increase risks during the upgrade process. Backups should remain enabled to ensure recovery options.