Exam Professional Cloud Database Engineer topic 1 question 86 discussion

A loogs good. B is impossible because you can't hold maintenance for more than a 90 days period

A. This is a maintenance deny question, so eliminate C and D. Maintenance deny periods can be set that last up to 90 days. That eliminates B since the period mentioned would be 107 days. B is also eliminated because the maintenance windows are an hour. You can't set a maintenance window in Cloud SQL to be 5 hours. A is the answer.

https://cloud.google.com/sql/docs/mysql/maintenance You can have a deny maintenance period even if you don't have maintenance windows configured for your instance. Deny maintenance periods can span from 1 to 90 days.

Option D allows you to create a Cloud Scheduler job to start maintenance at 12 AM on Sundays and pause the Cloud Scheduler job between November 1 and January 15. This will allow you to perform routine maintenance on Sundays, when traffic is slow, and avoid maintenance during the holiday shopping season, when traffic is highest. This option is the most complete and secure, as it allows you to ensure that your production system is available 24/7 during the holidays.

A: https://cloud.google.com/sql/docs/mysql/maintenance https://cloud.google.com/sql/docs/mysql/maintenance#management

correct answer is 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.

A: Define a maintenance window on Sundays between 12 AM and *****1 AM, and deny maintenance periods between November 1 and ***** January 15. Cloud SQL offers you the ability to configure maintenance updates through a set of maintenance settings. You can configure maintenance to be scheduled at times when brief downtime causes the lowest impact to your applications. For each Cloud SQL instance, you can configure the following: • Maintenance window. The day of the week and the hour in which Cloud SQL schedules maintenance. Maintenance windows last for ***** one hour. Learn how to configure a maintenance window.