nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #58

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #58: Real Exam Question with Answer & Explanation

The correct answer is A: Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance. 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

Ensure Database Reliability and Availability

Question

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?

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

Explanation

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

Topics

#Cloud SQL#Database Maintenance#High Availability#Operational Management

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions