Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 269 discussion

C. Create a read replica of the primary database and have the business analysts run their queries. Creating a read replica of the primary RDS database will offload the read-only SQL queries from the primary database, which will help to improve the performance of the web application. Read replicas are exact copies of the primary database that can be used to handle read-only traffic, which will reduce the load on the primary database and improve the performance of the web application. This solution can be implemented with minimal changes to the existing web application, as the business analysts can continue to run their queries on the read replica without modifying the code.

". A solutions architect needs to solve the problem with minimal changes to the existing web application." ABD all require major changes to the application. A: DynamoDB is NoSQL so big change B: Elasticache is a caching layer which require code change normally significant code change D: Redshift is analytics so not a solution

. While DynamoDB is a scalable NoSQL database, it requires changes to the application's data model and query patterns. B. ElastiCache is an in-memory data store that can improve query performance, but it is primarily used for caching rather than running complex queries. D. Redshift is a powerful data warehousing solution, but migrating the data and adapting the queries to Redshift's columnar architecture would require significant changes to the application and query logic. Therefore, option C is the most appropriate recommendation as it leverages read replicas in RDS to offload read-only query traffic from the primary database, allowing the business analysts to run their queries without impacting the performance of the web application. It provides a scalable and efficient solution with minimal changes to the existing web application.

C. Create a read replica of the primary database and have the business analysts run their queries

A. While DynamoDB is a scalable NoSQL database, it requires changes to the application's data model and query patterns. B. ElastiCache is an in-memory data store that can improve query performance, but it is primarily used for caching rather than running complex queries. D. Redshift is a powerful data warehousing solution, but migrating the data and adapting the queries to Redshift's columnar architecture would require significant changes to the application and query logic. Therefore, option C is the most appropriate recommendation as it leverages read replicas in RDS to offload read-only query traffic from the primary database, allowing the business analysts to run their queries without impacting the performance of the web application. It provides a scalable and efficient solution with minimal changes to the existing web application.

C, no doubt.

C is correct answer

Create a read replica of the primary database and have the business analysts run their queries.