exam questions

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

Exam Professional Cloud Architect topic 1 question 25 discussion

Actual exam question from Google's Professional Cloud Architect
Question #: 25
Topic #: 1
[All Professional Cloud Architect Questions]

During a high traffic portion of the day, one of your relational databases crashes, but the replica is never promoted to a master. You want to avoid this in the future.
What should you do?

  • A. Use a different database
  • B. Choose larger instances for your database
  • C. Create snapshots of your database more regularly
  • D. Implement routinely scheduled failovers of your databases
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
Narigdo
Highly Voted 5 years, 2 months ago
Answer is D
upvoted 100 times
Jos
5 years, 1 month ago
Yep, +1 for D
upvoted 20 times
...
...
Eroc
Highly Voted 5 years, 3 months ago
@chiar, I agree the question i s not clear. In GCP larger instances have larger number of CPUs, Memory and come with their own private network. So increases the instance size would help prevent the need for failover during high traffic times. However, routinely scheduled failovers would allow the team to test the failover when it is not requried. This would make sure it is working when it is required.
upvoted 45 times
Shariq
5 years, 2 months ago
exactly how do you know the optimal size. it will be a guess. answer should be D
upvoted 9 times
...
...
hpf97
Most Recent 1 week, 1 day ago
Selected Answer: D
D : Chaos testing
upvoted 1 times
...
alihabib
1 week, 4 days ago
Selected Answer: D
D - I think question is related to resiliency & disaster recovery, no matter how big or small the instance is.. Is the application able to achieve its RTO & RPO ?.. We don't know what cause the crash, but we could have avoided it if we had a Routine Scheduled Failovers Check done in past rather than anticipating & waiting for a real crash.
upvoted 1 times
...
alihabib
2 months ago
Selected Answer: D
Only a routine check, would indicate a best practice. Larger Instance doesn't guarantee a failover would be prevented
upvoted 1 times
...
Ekramy_Elnaggar
2 months, 3 weeks ago
Selected Answer: D
1. Proactive Testing: Regularly scheduled failovers proactively test your database's ability to recover and ensure the replica can successfully take over as the master. This helps identify and address any issues in the failover process before a real crisis occurs. 2. Confidence in Failover: By routinely testing failover, you gain confidence that your system can recover automatically in case of a primary database failure, minimizing downtime and data loss. 3. Improved Recovery Time: Regular failovers help optimize the recovery process, reducing the time it takes to switch to the replica.
upvoted 3 times
...
beagle_Masato
3 months ago
Selected Answer: D
Answer is D
upvoted 1 times
...
james2033
8 months, 1 week ago
Selected Answer: D
- **A. Use a different database**: Simply switching to a different database does not inherently solve the problem of failover and promotion mechanisms. The issue is more about the setup and management of failover strategies rather than the specific database technology used. - **B. Choose larger instances for your database**: While using larger instances might improve performance and potentially reduce the risk of a crash due to resource constraints, it does not address the failover mechanism. The key problem is the replica not being promoted, which larger instances alone won't fix. - **C. Create snapshots of your database more regularly**: Regular snapshots are useful for backups and recovery but do not help with automatic failover and high availability. Snapshots do not ensure that a replica will be promoted to a master if the primary fails.
upvoted 3 times
...
huuthanhdlv
8 months, 2 weeks ago
I think the answer is B, as the most important thing is customer experience. We can NOT expect database fails as a normal event which have direct customer and business impacts (if current data base fail because of load then replica database may fail as well). Of course we need to setup the failover process to work, but the more important task will be to increase database load first, thus I choose B.
upvoted 1 times
...
Jen3
11 months ago
I think the answer is D because we can not assume the crash was due to load.
upvoted 1 times
Jen3
11 months ago
Further the issue isn't that a crash occurred, the issue is the contingency that was in place didn't kick in. Hence D as my choice.
upvoted 2 times
...
...
ashishdwi007
1 year ago
Selected Answer: D
D is correct with given choice, because what if larger instance size is also failed. How ever question ignores logging and networking completely, the best way is to use logging why the DB is crashed, failover is just a remedy to solve the issues at current, not solving the problem itself.
upvoted 2 times
...
discuss24
1 year, 1 month ago
It is important to identify key words, the issue is replica not being promoted when primary instance fails. Regular testing would identify issue
upvoted 2 times
...
AWS_Sam
1 year, 1 month ago
The correct answer is D The question is asking how to avoid the situation of not failing over. The answer is to test the failover procedure. The question does *NOT*ask about what happens in the future and whether the secondary node is large enough.
upvoted 1 times
...
pakilodi
1 year, 2 months ago
Selected Answer: D
I would say D. Beacuse also B is correct, but you have a replica here, that is never promoted. So we need failover strategy.
upvoted 1 times
...
owenshinobi
1 year, 2 months ago
Selected Answer: B
My Answer is B Why not D ? I think - Each day we cannot know. What times of the day are peak usage times? Implementing routinely scheduled failovers won't solve the problem. - if Implement routinely scheduled failovers of your databases but replica database server is a same spec with main database server , replica database server will crashes by high traffic portion same a main database server
upvoted 2 times
...
Nora9
1 year, 3 months ago
Selected Answer: D
Answer is D. Implement routinely scheduled failovers of your databases This option is most aligned with addressing the issue. Routine failovers can help ensure that the failover process is working correctly and that the system is resilient to crashes. It can be part of a disaster recovery plan, where you routinely test the failover to the replica to ensure that it can handle being promoted to a master if needed. For the above reasons, i believe D is correct.
upvoted 1 times
...
piiizu
1 year, 4 months ago
Why not B? Using a large instance during low traffic hours means incurring more cost than benefit except the instance is elastic. Therefore using a larger instance is not cost effective and the answer is D.
upvoted 1 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