Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
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.
B.
You don’t open a support ticket to prevent maintenance on a managed Cloud SQL instance. Eliminate A. C and D both involve additional costs which the question says is a concern. That leaves B. In Maintenance - Advanced Options you can define a maintenance deny period which can be up to 90 days. So B is the right answer.
CloudSQL - Edit instance - Maintenance:
Deny maintenance period
You can deny upcoming maintenance by creating a deny period, which can last up to 90 days. You can only have one deny period in effect at a time.
B: Use Cloud SQL maintenance settings to prevent *** any maintenance during the month of December.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dynamic_dba
Highly Voted 4 months, 3 weeks ago887ad17
Most Recent 1 week, 3 days agoBoumer
2 months, 2 weeks agochelbsik
7 months, 2 weeks agopk349
7 months, 2 weeks ago