An ecommerce company’s Amazon RDS web application performance degrades due to an increase in read-only SQL queries from business analysts. A solutions architect needs to resolve the issue with minimal changes to the web application. What should the solutions architect recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a read replica of the primary database and have the business analysts run their queries..
Why this is the answer
Creating a read replica offloads read-only queries from the primary database, improving its performance for the web application. Business analysts can then query the replica without impacting the production database. This requires minimal application changes because the web application continues to interact with the primary database as before. Exporting to DynamoDB or copying to Redshift would require significant data migration and changes to how analysts query the data. Loading into ElastiCache is for caching frequently accessed data, not for running complex analytical queries directly.
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