What is the best practice for creating a highly available PostgreSQL database in RDS that can sustain the loss of a single AWS region?

Digital Marketing, LinkedIn Amazon Web Services (AWS) Skill Quiz Answers

You no longer need to be worried if you are taking the LinkedIn Amazon Web Services (AWS) Skill Quiz Exam and are unsure about the proper answer to the question “What is the best practice for creating a highly available PostgreSQL database in RDS that can sustain the loss of a single AWS region?”. I have provided the right answer to your question below.

What is the best practice for creating a highly available PostgreSQL database in RDS that can sustain the loss of a single AWS region?

Options

  • Verify that your instance is configured for Multi-AZ support. Database changes will be automatically synced to another region in the event of a failure and RDS will automatically select a new master until the regional failure is resolved.
  • PostgreSQL cannot be replicated across regions. Restore the database backups from an S3 bucket and repoint your database connections to the new instance.
  • Create Read Replicas in other AWS regions. Ensure read operations against the database occur on an available Read Replica, and send write operations to another region if you need to promote a Read Replica to a standalone database if the master is down.
  • Create Read Replicas in other AWS regions. You can designate a new master database from any of the read replicas until the regional failure is resolved.

The Correct Answer Is:

  • Create Read Replicas in other AWS regions. Ensure read operations against the database occur on an available Read Replica, and send write operations to another region if you need to promote a Read Replica to a standalone database if the master is down.

Conclusion

I believe I was successful in answering your query “What is the best practice for creating a highly available PostgreSQL database in RDS that can sustain the loss of a single AWS region?”. I hope you easily pass the certification exam and get the certificate as soon as possible. Have a great time! Good luck!