Google Cloud Professional Cloud Database Engineer — Question 99

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

Answer options

• A. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
• B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
• C. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
• D. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Correct answer: B

Explanation

The correct answer is B because using Cloud SQL maintenance settings allows you to specifically prevent any scheduled maintenance that could lead to downtime. Option A is incorrect as opening a support ticket does not guarantee the avoidance of maintenance. Options C and D suggest creating replicas or regional instances, which may not directly address the requirement of avoiding planned maintenance and could incur additional costs.