ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 770 - SAA-C03 discussion

Report
Export

A global ecommerce company runs its critical workloads on AWS. The workloads use an Amazon RDS for PostgreSQL DB instance that is configured for a Multi-AZ deployment.

Customers have reported application timeouts when the company undergoes database failovers. The company needs a resilient solution to reduce failover time

Which solution will meet these requirements?

A.
Create an Amazon RDS Proxy. Assign the proxy to the DB instance.
Answers
A.
Create an Amazon RDS Proxy. Assign the proxy to the DB instance.
B.
Create a read replica for the DB instance Move the read traffic to the read replica.
Answers
B.
Create a read replica for the DB instance Move the read traffic to the read replica.
C.
Enable Performance Insights. Monitor the CPU load to identify the timeouts.
Answers
C.
Enable Performance Insights. Monitor the CPU load to identify the timeouts.
D.
Take regular automatic snapshots Copy the automatic snapshots to multiple AWS Regions
Answers
D.
Take regular automatic snapshots Copy the automatic snapshots to multiple AWS Regions
Suggested answer: A

Explanation:

Amazon RDS Proxy: RDS Proxy is a fully managed, highly available database proxy that makes applications more resilient to database failures by pooling and sharing connections, and it can automatically handle database failovers.

Reduced Failover Time: By using RDS Proxy, the connection management between the application and the database is improved, reducing failover times significantly. RDS Proxy maintains connections in a connection pool and reduces the time required to re-establish connections during a failover.

Configuration:

Create an RDS Proxy instance.

Configure the proxy to connect to the RDS for PostgreSQL DB instance.

Modify the application configuration to use the RDS Proxy endpoint instead of the direct database endpoint.

Operational Benefits: This solution provides high availability and reduces application timeouts during failovers with minimal changes to the application code.

Amazon RDS Proxy

Setting Up RDS Proxy

asked 16/09/2024
Morris Djavaheri
29 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first