Amazon Exam SAP-C02 Topic 10 Question 31 Discussion

Actual exam question for Amazon's SAP-C02 exam

Question #: 31
Topic #: 10

A public retail web application uses an Application Load Balancer (ALB) in front of Amazon EC2 instances running across multiple Availability Zones (AZs) in a Region backed by an Amazon RDS MySQL Multi-AZ deployment. Target group health checks are configured to use HTTP and pointed at the product catalog page. Auto Scaling is configured to maintain the web fleet size based on the ALB health check.

Recently, the application experienced an outage. Auto Scaling continuously replaced the instances during the outage. A subsequent investigation determined that the web server metrics were within the normal range, but the database tier was experiencing high toad, resulting in severely elevated query response times.

Which of the following changes together would remediate these issues while improving monitoring capabilities for the availability and functionality of the entire application stack for future growth? (Select TWO.)

AConfigure read replicas for Amazon RDS MySQL and use the single reader endpoint in the web application to reduce the load on the backend database tier.

BConfigure the target group health check to point at a simple HTML page instead of a product catalog page and the Amazon Route 53 health check against the product page to evaluate full application functionality. Configure Ama7on CloudWatch alarms to notify administrators when the site fails.

CConfigure the target group health check to use a TCP check of the Amazon EC2 web server and the Amazon Route S3 health check against the product page to evaluate full application functionality. Configure Amazon CloudWatch alarms to notify administrators when the site fails.

DConfigure an Amazon CtoudWatch alarm for Amazon RDS with an action to recover a high-load, impaired RDS instance in the database tier.

EConfigure an Amazon Elastic ache cluster and place it between the web application and RDS MySQL instances to reduce the load on the backend database tier.

Show Suggested Answer

Suggested Answer: A, E

Configuring read replicas for Amazon RDS MySQL and using the single reader endpoint in the web application can significantly reduce the load on the backend database tier, improving overall application performance. Additionally, implementing an Amazon ElastiCache cluster between the web application and RDS MySQL instances can further reduce database load by caching frequently accessed data, thereby enhancing the application's resilience and scalability. These changes address the root cause of the outage by alleviating the database tier's high load and preventing similar issues in the future.

by Malcolm at May 18, 2024, 12:48 PM

Limited Time Offer

25%

Off

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Nadine

6 months ago

Wait, did someone say 'Amazon Route S3'? I'm pretty sure that's not a thing, but I'd love to see someone try to configure a health check against it!

upvoted 0 times

...

Maricela

6 months ago

Option E with the Amazon Elastic Cache cluster could be a clever solution to reduce the load on the database. I'd be curious to see how that performs compared to the read replica approach.

upvoted 0 times

...

7 months ago

Option A looks promising, but I wonder if read replicas alone will be enough to handle the high load on the database tier. We might need to consider additional measures to offload the database.

upvoted 0 times

Reuben

6 months ago

B: That's a good point. Adding an Amazon Elasticache cluster could definitely help with offloading the database.

upvoted 0 times

...

Frank

6 months ago

A: I think we should also consider option E to reduce the load on the backend database tier.

upvoted 0 times

...