SAP-C02 Exam - Question 443

Question

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 load, 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? (Choose two.)

Examice · Accepted Answer

To remediate the issue and improve monitoring capabilities, two critical changes should be implemented. First, configure 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. This ensures that read operations are distributed among replicas, alleviating the strain on the primary database instance during high load scenarios. Second, placing an Amazon ElastiCache cluster between the web application and RDS MySQL instances can also reduce the load on the backend database tier by caching frequently accessed data. This improves response times and overall application performance, thus addressing the elevated query response times experienced during high load periods.

pangchn · Answer

My answer is a bit difference.
It doesn't mentioned read-only scnerio so read replica in A may not able to help
compare B and C, both pro and con. I lean to B from both the real world and in this particual question to bypass the database

Capt_Leonidas · Answer

https://www.examtopics.com/discussions/amazon/view/46826-exam-aws-certified-solutions-architect-professional-topic-1/

w3ap0nx · Answer

"for future growth" -> E (cache in front of the DB)

ovladan · Answer

Selected Answer: BE
B: Will improve web app
D: Will improve database high load issue and query response times.

titi_r · Answer

B and E.

djangoUnchained · Answer

B. Health check is failing because the application cannot read from the DB, event though the EC2 instance is fine. As a result the ALB is terminating the EC2 instance unnecessarily.

Russs99 · Answer

A and B are my picks

seetpt · Answer

BE for me

Dgix · Answer

First of all: the instances are terminated because the load on the DB is too high.

A: Best way to reduce the load on the DB. It doesn't notify admins, though, which means we then need either B or C (D and E do not notify admins).
B: Health checks do not burden the site as they are done relatively seldom, so trying to reduce load by using a page that's lighter on the DB is not very relevant. Notifies admins.
C: TCP checks are lighter on the load than HTTP checks, which means the already slight overhead for health checks is reduced further than in B. Notifies admins. This is preferable to B, but both feel inconsequential.
D: Recovery actions in this situation are out of scope. This alternative is there to confuse.
E: An alternative to A, but it has operational overhead in that the application must be changed to use the cache. A is more straightforward.

Thus A and C.

AWSPro1234 · Answer

I agree with A and B .

failexamonly · Answer

read replica to reduce load.
tcp check to see if ec2 is reachable

VerRi · Answer

TCP check is like a heartbeat check, too rough.

red_panda · Answer

A and B are my answers.
A instead of E only because we have no tips that indicate the necessity to have a caching systems. For example, it say "high load on database", but nothing about same record read more more time.
So for me A and B

michele_scar · Answer

When you talking about a product catalog page, you need to cache information (text, images) to leverage the load on the data tier. ElastiCache is the solution (or a CDN).

Dgix · Answer

By the way, ExamTopics, we get a 503 when submitting voting comments. Please change my previous submission to that type, specifying A and C.

9f02c8d · Answer

A & E is correct answer as the monitoring aspect is not part of the problem statement

vip2 · Answer

B and E works as expection.
Due to web app is normal, A and C can not help
CloudWatch alarm can not support so complicated action

SAP-C02 Exam - Question 443

Discussion