Exam Professional Cloud Database Engineer topic 1 question 86 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 86
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by pk349 at Dec. 24, 2022, 11:41 p.m.

Comments

Submit Cancel

chelbsik

Highly Voted 2 years, 1 month ago

Selected Answer: A

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

upvoted 10 times

FunkyB

1 year, 12 months ago

Correct Answer: A "Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance

upvoted 1 times

...

dynamic_dba

Highly Voted 1 year, 10 months ago

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.

upvoted 5 times

...

Pime13

Most Recent 9 months, 1 week ago

Selected Answer: A

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.

upvoted 1 times

...

Pime13

1 year, 3 months ago

Selected Answer: A

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

upvoted 2 times

...

learnazureportal

1 year, 4 months ago

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.

upvoted 1 times

...

pk349

2 years, 1 month ago

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.

upvoted 2 times

...