Q19 — AWS SAA-C03 Ch.6

Question 19 of 65 | ← Chapter 6

Q384. A company manages an application that stores data on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Increases in traffic are causing performance problems. The company determines that database queries are the primary reason for the slow performance.What should a solutions architect do to improve the application's performance?

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

Explanation

Creating a read replica from the source DB instance allows you to offload read traffic from the primary database, distributing the load and improving overall performance. The read replica can handle read queries, while the primary DB instance focuses on write operations. This architecture helps to scale the application's read capacity and reduces the load on the primary database.Option A (serving read traffic from the Multi-AZ standby replica) is incorrect because Multi-AZ replication is primarily used for high availability and failover, not for scaling read traffic.Option B (configuring the DB instance to use Transfer Acceleration) is unrelated to the database performance issue described in the question. Transfer Acceleration is a feature Amazon S3 that improves data transfer speeds to and from S3 buckets.Option D (using Amazon Kinesis Data Firehose between the application and Amazon RDS to increase the concurrency of database requests) is also unrelated to the database performance issue. Amazon Kinesis Data Firehose is a service for ingesting and delivering streaming data, and it does not directly address the query performance problem.