A company runs an application that stores data on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Increased traffic is causing performance problems, and database queries are identified as the primary bottleneck. What should a solutions architect do to improve application performance?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a read replica from the source DB instance. Serve read traffic from the read replica..
Why this is the answer
The correct solution is to create a read replica and offload read traffic to it. Amazon RDS read replicas allow you to scale out beyond the capacity of a single DB instance for read-heavy database workloads. This reduces the load on the primary Multi-AZ instance, which can then focus on write operations and critical transactions, improving overall application performance. Serving read traffic from the Multi-AZ standby replica is incorrect because the standby replica is primarily for high availability and failover, not for scaling read performance. It doesn't actively serve read traffic under normal operations. Transfer Acceleration is for accelerating data transfer to and from S3, not for improving RDS database query performance. Kinesis Data Firehose is used for capturing, transforming, and loading streaming data to data stores and analytics services, not for increasing the concurrency of direct database requests to RDS to solve a query bottleneck.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed