Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Database Engineer Exam - Topic 7 Question 20 Discussion

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
C) Delete DB-2 so that DB-1 automatically reverts to the primary instance.
A) Bring DB-1 back online.
B) Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
D) Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Google Professional Cloud Database Engineer Exam - Topic 7 Question 20 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 20
Topic #: 7
[All Professional Cloud Database Engineer Questions]

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Markus at Oct 04, 2023, 09:41 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Stefany
9 months ago
How does promoting a replica work exactly?
upvoted 0 times
...
Tegan
10 months ago
Definitely not B, that seems unnecessary.
upvoted 0 times
...
Donte
10 months ago
Wait, can you really just delete DB-2? Sounds risky.
upvoted 0 times
...
Erin
10 months ago
I think option C makes sense too!
upvoted 0 times
...
Isreal
10 months ago
Just bring DB-1 back online, right?
upvoted 0 times
...
Orville
10 months ago
I don't recall us covering promoting a new read replica like DB-4 in this context, so I think that option might be a distraction.
upvoted 0 times
...
Pamella
11 months ago
I feel like we discussed the importance of keeping the primary instance intact, so option A seems like it could be correct, but I’m not 100% confident.
upvoted 0 times
...
Roxanne
11 months ago
I remember a practice question where we had to delete a replica to revert to the primary, so maybe deleting DB-2 could work here?
upvoted 0 times
...
Slyvia
11 months ago
I think we might need to bring DB-1 back online first, but I'm not entirely sure if that's the right step.
upvoted 0 times
...
Kirk
11 months ago
I think the key here is that we want to return to the pre-test configuration. That means bringing DB-1 back online and making it the primary instance again. The other options don't seem to achieve that.
upvoted 0 times
...
Cheryll
11 months ago
I'm a bit confused by this question. Can we really just bring DB-1 back online, or do we need to do something else to restore the original setup? I want to make sure I understand this properly.
upvoted 0 times
...
Maryann
11 months ago
Okay, let's see. We need to return to the pre-test configuration, so deleting DB-2 or creating a new replica doesn't seem right. I'm leaning towards bringing DB-1 back online.
upvoted 0 times
...
Krystina
11 months ago
Hmm, I'm not sure about this one. I need to think through the options carefully to make sure I don't miss anything.
upvoted 0 times
...
Heike
11 months ago
This seems straightforward - I think the answer is to just bring DB-1 back online since it was the primary instance before the test.
upvoted 0 times
...
Coletta
11 months ago
This seems straightforward enough. The question is asking for two valid ways to issue the traceSBC command, so I'll choose the two options that seem the most direct and appropriate.
upvoted 0 times
...
Lawrence
11 months ago
Hmm, I'm a bit confused by this question. I'll need to review my notes on logistic regression to make sure I understand the potential issues with this approach.
upvoted 0 times
...
Elinore
11 months ago
Hmm, I'm not too sure about this one. I'll have to think it through carefully.
upvoted 0 times
...

Save Cancel