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…

Question

Options

• AOpen a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during
• BUse Cloud SQL maintenance settings to prevent any maintenance during the month of
• CCreate MySQL read replicas in different zones so that, if any downtime occurs, the read replicas
• DCreate a MySQL regional instance so that, if any downtime occurs, the standby instance will act

• A
  4% (1)
• B
  81% (22)
• C
  11% (3)
• D
  4% (1)

Explanation

Cloud SQL provides a 'deny maintenance period' setting that lets you specify windows of time (up to 90 days) during which Google will not perform disruptive maintenance on your instance. Setting a deny period for December directly addresses the no-planned-downtime requirement at no additional cost - making it the most cost-effective solution. Option A (support ticket) is not an official mechanism for blocking maintenance; Google does not guarantee maintenance deferral via support tickets. Option C (read replicas) adds cost and doesn't prevent maintenance on the primary. Option D (regional instance / HA) adds cost and protects against unplanned failures, not planned maintenance windows.

No community discussion yet for this question.