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

Suggested Answer: A 🗳️

by jitu028 at Dec. 22, 2022, 5:14 p.m.

Comments

Submit Cancel

chelbsik

Highly Voted 2 years, 5 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 6 months, 1 week 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

1 year, 1 month ago

Selected Answer: A

A because maintenance should be on the time with minimal impact

upvoted 2 times

...

goodsport

1 year, 9 months ago

Selected Answer: A

A is the correct answer.

upvoted 3 times

...

dynamic_dba

2 years, 3 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

2 years, 3 months ago

Selected Answer: A

A is right.

upvoted 1 times

...

ssaporylo

2 years, 5 months ago

Vote for A. Configure time slot for maintainance HA for fail over but also has maintainance window

upvoted 4 times

...

pk349

2 years, 5 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

...