exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 9 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 9
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

  • A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
  • B. Create your database with one primary node and one read replica in the region.
  • C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
  • D. Configure your Cloud SQL instance with high availability enabled.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
chelbsik
Highly Voted 1 year, 12 months ago
Selected Answer: A
Since we don't really need HA and we have a window that users are not need our app - A is fine, and D looks like an overkill
upvoted 10 times
...
orvalver
Most Recent 1 week, 5 days ago
Selected Answer: A
The key term here is the maintenance window, if we see MW we can work to configure it. Letter A.
upvoted 1 times
...
hanayome
7 months, 2 weeks ago
Selected Answer: A
A because maintenance should be on the time with minimal impact
upvoted 2 times
...
goodsport
1 year, 3 months ago
Selected Answer: A
A is the correct answer.
upvoted 3 times
...
dynamic_dba
1 year, 9 months ago
A. Google controls maintenance which could cause some downtime. Hence D would be irrelevant. C seems like a lot of work. B is also irrelevant. That leaves A as the best answer since you can choose your maintenance window to be after users will not be using the system. The addition of the earlier and later information is fluff and is not relevant to the question.
upvoted 4 times
...
Nirca
1 year, 9 months ago
Selected Answer: A
A is right.
upvoted 1 times
...
ssaporylo
1 year, 11 months ago
Vote for A. Configure time slot for maintainance HA for fail over but also has maintainance window
upvoted 4 times
...
pk349
1 year, 12 months ago
A: Configure a maintenance window ***** during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
upvoted 4 times
...
GCP72
2 years ago
6AM to 10PM
upvoted 1 times
...
GCP72
2 years ago
Selected Answer: A
A is the correct answer because application is used between
upvoted 3 times
...
jitu028
2 years ago
Selected Answer: D
Correct answer - D https://cloud.google.com/sql/docs/mysql/high-availability#HA-configuration
upvoted 2 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago