Google Professional Cloud Database Engineer Exam - Topic 11 Question 8 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 8
Topic #: 11

[All Professional Cloud Database Engineer Questions]

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

ADefine a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

BDefine a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

CBuild a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

DCreate a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

Show Suggested Answer

Suggested Answer: B

by Twana at Oct 14, 2022, 01:32 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Elmer

4 months ago

D sounds complicated, not sure it’s necessary.

upvoted 0 times

...

Gabriele

4 months ago

I agree with A, it’s the safest choice.

upvoted 0 times

...

Mignon

4 months ago

Surprised they even suggest maintenance during holidays!

upvoted 0 times

...

Lindsey

4 months ago

I think B is too long for the maintenance window.

upvoted 0 times

...

Shonda

4 months ago

Option A seems solid, keeps it simple.

upvoted 0 times

...

Alisha

5 months ago

I believe we had a similar question where we had to deny maintenance during peak times. I think option D might be the right choice since it involves scheduling.

upvoted 0 times

...

Casey

5 months ago

I vaguely recall something about using Cloud Scheduler for maintenance tasks, but I can't remember if it was the best approach for this scenario.

upvoted 0 times

...

Louisa

5 months ago

I think option A sounds familiar, but I feel like we practiced a question where the maintenance period was longer. Was it 5 AM instead of 1 AM?

upvoted 0 times

...

Rory

5 months ago

I remember we discussed the importance of defining maintenance windows, but I'm not sure if the timing should be longer than an hour.

upvoted 0 times

...

Chi

5 months ago

I'm a bit unsure on this one. The question mentions "new, long-term securities," so I'm wondering if a public issue could also involve a best efforts offering. I'll have to review my notes to be sure.

upvoted 0 times

...

Emily

5 months ago

Hmm, I'm a bit unsure about this one. I know vRealize Automation can integrate with different VMware products, but I'm not entirely sure which one is specifically used for importing Cloud Templates from the Marketplace. I'll have to think this through carefully.

upvoted 0 times

...

Alona

5 months ago

I'm a bit confused on the best approach here. Should I create separate main accounts for each principal, or can I just use an advanced rule for the Shareholder distribution account? I'll need to review the details carefully.

upvoted 0 times

...