Answer-first summary for fast verification
Answer: Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
The question asks for a solution to ensure the production MySQL database on Cloud SQL is available 24/7 during the year-end holiday shopping season by skipping routine maintenance during that period. Option A is correct because it precisely defines a maintenance window on Sundays between 12 AM and 1 AM, which is when traffic is slow, and it denies maintenance periods between November 1 and January 15, covering the holiday season. Option B extends the maintenance window unnecessarily and the denial period beyond the holiday season, which is not required. Option C suggests using Cloud Composer for a task that can be directly managed within Cloud SQL's settings, making it overly complex. Option D proposes using Cloud Scheduler to start maintenance, which is not the most straightforward method for managing maintenance windows in Cloud SQL. Therefore, the most straightforward and correct answer is A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you ensure your production MySQL database on Cloud SQL remains available 24/7 during the year-end holiday shopping season while skipping routine maintenance scheduled for Sunday midnight?
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.