How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?

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 “How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?”. I have provided the right answer to your question below.

How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?

Options

  • You can not set up an active-active architecture for SQL Server that spans geographic regions.
  • Use a VPN or VPC peering to establish a connection between the VPCs in each region. Install SQL Server Enterprise Edition on EC2 instances in each region and configure an Always On availability group.
  • Use RDS for SQL Server 2016 or 2017 Enterprise Edition. Enable Multi-AZ support and select the Mirroring/Always On option. Select another region for the mirroring option.
  • Use RDS for SQL Server and create the same instance in two different regions. Use Database Migration Service to keep each database in sync.

The Correct Answer Is:

  • Use RDS for SQL Server 2016 or 2017 Enterprise Edition. Enable Multi-AZ support and select the Mirroring/Always On option. Select another region for the mirroring option.

Conclusion

I believe I was successful in answering your query “How do you architect a solution for an SQL Server database to be replicated across AWS regions in an active-active architecture?”. I hope you easily pass the certification exam and get the certificate as soon as possible. Have a great time! Good luck!