Google Cloud Professional Cloud Database Engineer — Question 82

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 during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

Answer options

• A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
• B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
• C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
• D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

Correct answer: A

Explanation

The correct answer is A because it precisely defines a maintenance window that aligns with the least traffic period while also ensuring that maintenance is not performed during the critical holiday shopping season. Options B and C either extend the maintenance window or have incorrect denial periods, which would not effectively prevent maintenance during the holidays. Option D does not prevent the scheduling of maintenance, which could still occur during the holiday timeframe.