SAA-C03 Question 203
Single answerYour company runs a high-traffic e-commerce platform using Amazon RDS for MySQL. You have noticed a significant increase in the number of database connections during peak hours, leading to connection limits being exceeded and degraded performance. How can you use Amazon RDS Proxy to address this issue?
- A
Amazon RDS Proxy pools and manages database connections, reducing the overhead of opening and closing database connections frequently.
- B
Amazon RDS Proxy replicates your database to handle the increased number of connections and distributes the load across replicas.
- C
Amazon RDS Proxy automatically scales the underlying database instance to handle the increased number of connections.
- D
Amazon RDS Proxy caches query results to reduce the number of queries sent to the database.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is designed to manage and pool database connections, which is particularly useful for applications experiencing high connection churn or exceeding connection limits. By reusing existing connections, it reduces the overhead of establishing new connections and improves database performance during peak traffic periods. It does not replicate databases, scale the underlying database instance, or cache query results.
- A. Correct.
This is correct. Amazon RDS Proxy establishes and manages a pool of database connections, which helps applications reuse existing connections rather than creating new ones, reducing the load on the database.
- B. Incorrect.
This is incorrect. Amazon RDS Proxy does not replicate databases or distribute load across replicas. It focuses on connection pooling and management.
- C. Incorrect.
This is incorrect. Amazon RDS Proxy does not scale the database instance. Scaling the database is a separate action managed by the user or through mechanisms like Amazon Aurora’s auto-scaling.
- D. Incorrect.
This is incorrect. Amazon RDS Proxy does not cache query results. Its primary function is connection pooling and improving database connection handling.