
Answer-first summary for fast verification
Answer: Use Cloud SQL maintenance settings to prevent any maintenance during the month of December., Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
To address the company's need for a cost-effective solution with no planned downtime during December for their MySQL database migration to Cloud SQL, the best approach is to use Cloud SQL's built-in features for high availability and maintenance control. Option B is correct because it directly addresses the concern of preventing maintenance during a specific period without incurring additional costs, as Cloud SQL allows users to schedule maintenance windows. Option D is also correct because creating a MySQL regional instance provides high availability by automatically failing over to a standby instance in another zone within the same region in case of an outage, ensuring no downtime. This solution is cost-effective as it leverages Google Cloud's infrastructure without the need for additional read replicas, which would increase costs. Options A and C are less optimal; opening a support ticket (A) is not a scalable or guaranteed solution, and creating read replicas (C) adds unnecessary complexity and cost for the stated requirement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you migrate a MySQL database to Cloud SQL without any planned downtime in December while ensuring the solution is cost-effective?
A
Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
B
Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
C
Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
D
Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.