SOA-C02 Question 335
Select 2A company is running a PostgreSQL RDS instance and has observed high read latency during peak traffic periods. Upon further investigation, they notice that a significant portion of the read traffic comes from repeated queries to the same data. As a SysOps Administrator, which actions can you take to improve the read performance of the RDS instance?
- A
Enable Amazon RDS Proxy to optimize the connection pool and reduce query latency.
- B
Enable Performance Insights and analyze query performance to identify and optimize slow queries.
- C
Set up a read replica for the RDS instance and configure the application to direct read traffic to the replica.
- D
Increase the size of the RDS instance to a larger instance class.
- E
Enable automatic backups to reduce the performance impact of future manual backups.
Show answer and explanation
Correct answers: B, C
Explanation
To improve read performance for an RDS instance with high read latency caused by repeated queries, enabling Performance Insights can help identify and address inefficient queries. Additionally, setting up a read replica can offload read traffic from the primary instance, improving overall performance. Other options, such as enabling RDS Proxy or increasing the instance size, are not directly aligned with the described issue.
- A. Incorrect.
RDS Proxy is used for optimizing connection pooling, particularly for databases with unpredictable or high connection overhead. However, it does not directly address high read latency caused by repeated queries to the same data.
- B. Correct.
Performance Insights helps analyze database performance and identify slow queries. This can be useful in optimizing the database workload and improving performance efficiency.
- C. Correct.
Setting up a read replica allows read traffic to be distributed, reducing the load on the primary database and improving read performance.
- D. Incorrect.
Increasing the instance size can improve performance in some cases, but it is a costlier solution and does not specifically address high read latency caused by repeated queries to the same data.
- E. Incorrect.
Enabling automatic backups is unrelated to reducing read latency. It is primarily for data recovery purposes.