You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance du

Question

Options

• ADefine a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance
• BDefine a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance
• CBuild a Cloud Composer job to start a maintenance window on Sundays between 12 AM and
• DCreate a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud

• A
  71% (29)
• B
  7% (3)
• C
  17% (7)
• D
  5% (2)

Explanation

Cloud SQL allows you to define a preferred maintenance window (e.g., Sundays 12 AM–1 AM) AND separately allows you to deny or defer upcoming maintenance events. By defining the maintenance window AND using the 'deny maintenance' feature during the holiday period, you ensure that Google will not apply updates to your instance during that sensitive time. Option B uses a wider 5-hour window which is unnecessarily broad. Cloud Composer (C) cannot control Cloud SQL maintenance scheduling. Cloud Scheduler (D) cannot start or pause Google-managed Cloud SQL maintenance windows - maintenance is controlled through the Cloud SQL API/console deny-maintenance mechanism, not a user-triggered scheduler job.

No community discussion yet for this question.