Discuss Amazon SAP-C02 Exam Topic 9 Question 29

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.

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.

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

23 comments · newest first

Matthew 11 months ago

E seems like a good option to ease the DB load too.

Lorrine 11 months ago

Definitely need those CloudWatch alarms for better monitoring!

Dustin 11 months ago

Wait, why not just use a caching layer instead?

Terrilyn 11 months ago

I disagree, the health check should focus on the actual product page.

Jennifer 12 months ago

A read replica setup sounds like a solid plan!

Yoko 12 months ago

I think we talked about using CloudWatch alarms for RDS, so option D might be a good idea too. It could help in managing high-load situations effectively.

Jose 1 year ago

I feel like option E could also help with performance, but I’m not sure if it directly addresses the monitoring aspect we need to improve.

Gianna 1 year ago

I'm not entirely sure about the health checks. I think we practiced something similar, but I'm confused if TCP checks are better than HTTP checks for monitoring.

Sheridan 1 year ago

I remember we discussed the importance of read replicas in our study group. Option A seems like a solid choice to reduce the load on the database.

Sage 1 year ago

I'm leaning towards the options that involve adding caching and reducing the load on the database. The RDS recovery alarm could also be a helpful addition.

Vernice 1 year ago

Configuring the health checks to evaluate the full application functionality, including the product page, and setting up CloudWatch alarms sounds like a smart approach to improve monitoring and visibility.

Rozella 1 year ago

Okay, I think I've got a good handle on this. Configuring read replicas and using the single reader endpoint seems like a solid way to reduce the load on the database tier.

Ammie 1 year ago

Hmm, I'm a bit confused by the details here. I'll need to re-read the question and think through the different components of the application stack.

Tandra 1 year ago

This looks like a tricky question. I'll need to carefully consider the different options to determine the best solution.

Detra 1 year ago

The question mentions adjusting the configuration to address the "most worrying route." I'd try to identify what that specific route is and then determine the best way to influence the path selection.

Billi 1 year ago

Hmm, this is a tricky one. The ISTQB and IQBBA frameworks cover related but distinct areas, so I'll need to think through how the testing and business analysis activities might interact. I'll make sure to read the answer options closely.

Twila 1 year ago

I remember practicing a question like this, and I think Content Provider helps manage data sharing while keeping it secure.

Carline 2 years ago

So, a good combo could be A) for reducing load and B) for improved monitoring. Makes sense!

Dottie 2 years ago

I like B) better. HTML page health checks won’t help diagnose deeper issues. Route 53 health checks on the product page and CloudWatch alarms sound more thorough.

Eladia 2 years ago

Agreed, but it might be good to also monitor the entire application stack. Let’s consider options B and C for better monitoring.

Alpha 2 years ago

True. Configuring read replicas for RDS MySQL could reduce load. A) seems like a good option.

Dottie 2 years ago

Yeah, the outage issue points to the database tier being overloaded.

Carline 2 years ago

I think it's tricky to figure out which options to choose for the exam question.

Amazon SAP-C02 Exam - Topic 9 Question 29 Discussion