Q73 — AWS SAA-C03 Ch.15

Question 73 of 100 | ← Chapter 15

Q1173. A company manages an application that stores data on an Amazon RDS for PostgreSQL Multi-AZ DB instance. High traffic on the application is causing increased latency for many read queries.A solutions architect must improve the performance of the application.Which solution will meet this requirement?

Correct Answer: C. Create a read replica of the DB instance. Serve read traffic from the read replica.

Explanation

To improve the performance of an application that is experiencing increased latency for read queries on an Amazon RDS for PostgreSQL Multi-AZ DB instance, the best solution is:C. Create a read replica of the DB instance. Serve read traffic from the read replica.### Explanation:Read Replica: By creating a read replica, you can offload read traffic from the primary DB instance. This can significantly reduce latency for read queries, as read replicas can handle query loads independently. High Availability: Since the read replica is a separate instance, it can also enhance availability and scalability for read-heavy workloads.### Other Options:A: Enabling Amazon RDS Performance Insights helps analyze performance bottlenecks but does not directly resolve latency issues related to read queries.B: Configuring the DB instance to use DynamoDB Accelerator (DAX) is not applicable here since DAX is specifically for DynamoDB, not for RDS PostgreSQL.D: Using Amazon Data Firehose is not suited for increasing concurrency of database requests and does not directly address the read latency issue.Thus, option C is the most effective solution for improving read performance in this scenario.