nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #189

You have a Cloud SQL for MySQL Enterprise instance with four read replicas. Your next scheduled maintenance event is scheduled tomorrow at 6-PM. Your security team identifies an important security vul

The correct answer is C. Perform self-service maintenance on the primary instance during scheduled business downtime.. Cloud-SQL’s self-service maintenance feature lets you manually apply updates on demand-so you can patch the primary instance at 11-PM during your approved downtime rather than waiting for tomorrow’s window. Once the primary is updated and rebooted, you then repeat self-service ma

Managing database solutions

Question

You have a Cloud SQL for MySQL Enterprise instance with four read replicas. Your next scheduled maintenance event is scheduled tomorrow at 6-PM. Your security team identifies an important security vulnerability. You are notified by your management at 8-PM today to update your primary instance and all four read replicas during approved business downtime today at 11- PM. What should you do-

Options

  • AReschedule the upcoming scheduled maintenance to happen today at 11-PM.
  • BPerform self-service maintenance on the selected read replicas.
  • CPerform self-service maintenance on the primary instance during scheduled business downtime.
  • DReschedule the upcoming scheduled maintenance of the primary instance to apply updates

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    77% (20)
  • D
    15% (4)

Explanation

Cloud-SQL’s self-service maintenance feature lets you manually apply updates on demand-so you can patch the primary instance at 11-PM during your approved downtime rather than waiting for tomorrow’s window. Once the primary is updated and rebooted, you then repeat self-service maintenance on each read replica. This approach addresses the security vulnerability immediately while still operating within the agreed downtime.

Topics

#Cloud SQL Maintenance#Self-Service Maintenance#Security Updates#Database Operations

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice