test bank question

[mgough]

Hi

Just had a question about one of the questions/answers in the test bank for the AWS Database Specialty exam. I mostly agreed with the answer, being the cross region replica as the way to go. I had excluded it though because of the aws documentation stating that while you can create manual snapshots, you can’t create automatic ones on a rds postgres read replica.

Documentation was from:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

I’m assuming the question meant to say enable automatic backups after it has been promoted and is no longer a read replica

[Joboy-Pineda-TD]

Hello,

Thanks for your question. Upon reviewing the question and its objective, I understand the technical limitation with PostgreSQL RDS on automatic backups for cross-region read replica was not considered. We will update it accordingly.

To dissect the scenario, the cross-region read replica gives us confidence that the RPO and RTO will be achieved while the Step Functions is hard to guarantee as a DR strategy. Although the automatic backups feature is not supported for Postgre RDS, please note that it is still possible to create a job that runs a manual snapshot of the replica. This should achieve the requirement which asks for backups to be available for the replica. Nevertheless, because of the words chosen and phrases used for the supposed correct choice, it is arguable.

I also apologize for the late response, and I hope my reply helped you in your preparation. Thank you. We will update this question as soon.

Best,

Joboy Pineda