SAP-C02 · Question #702
A company runs an application in the cloud that consists of a database and a website. Users can post data to the website, have the data processed, and have the data sent back to them in an email. Data
The correct answer is A. Place the Tomcat server in an Auto Scaling group with multiple EC2 instances behind an C. Migrate the MySQL database to Amazon Aurora with one Aurora Replica. F. Create an additional public subnet in a different Availability Zone in the website VPC.. Increase the reliability of a two-VPC application with a single Tomcat EC2 instance website and a MySQL EC2 database, especially given website outages due to high traffic.
Question
A company runs an application in the cloud that consists of a database and a website. Users can post data to the website, have the data processed, and have the data sent back to them in an email. Data is stored in a MySQL database running on an Amazon EC2 instance. The database is running in a VPC with two private subnets. The website is running on Apache Tomcat in a single EC2 instance in a different VPC with one public subnet. There is a single VPC peering connection between the database and website VPC. The website has suffered several outages during the last month due to high traffic. Which actions should a solutions architect take to increase the reliability of the application? (Choose three.)
Options
- APlace the Tomcat server in an Auto Scaling group with multiple EC2 instances behind an
- BProvision an additional VPC peering connection.
- CMigrate the MySQL database to Amazon Aurora with one Aurora Replica.
- DProvision two NAT gateways in the database VPC.
- EMove the Tomcat server to the database VPC.
- FCreate an additional public subnet in a different Availability Zone in the website VPC.
How the community answered
(31 responses)- A65% (20)
- B19% (6)
- D10% (3)
- E6% (2)
Why each option
Increase the reliability of a two-VPC application with a single Tomcat EC2 instance website and a MySQL EC2 database, especially given website outages due to high traffic.
Placing the Tomcat server in an Auto Scaling group with multiple EC2 instances behind an Application Load Balancer distributes traffic, handles increased load, and provides high availability for the website component.
Provisioning an additional VPC peering connection does not directly address the reliability issues of the single EC2 instances or the database; a single peering connection is sufficient for connectivity.
Migrating the MySQL database to Amazon Aurora with an Aurora Replica improves database reliability, scalability, and availability by moving from a single EC2 instance database to a managed, fault-tolerant, and read-replica capable service.
Provisioning two NAT gateways in the database VPC is relevant for instances in private subnets needing outbound internet access, but it doesn't solve the core reliability issues of the website or the database itself in this scenario.
Moving the Tomcat server to the database VPC might simplify networking but doesn't inherently increase reliability if it remains a single instance or if the database is still a single point of failure; it doesn't address the scaling and high availability requirements.
Creating an additional public subnet in a different Availability Zone in the website VPC allows for deploying the load balancer and Auto Scaling group instances across multiple AZs, enhancing fault tolerance and high availability for the website.
Concept tested: High availability and scalability for web applications and databases
Source: https://docs.aws.amazon.com/autoscaling/ec2/userguide/what-is-auto-scaling.html AND https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html AND https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html
Community Discussion
No community discussion yet for this question.