A Public-Facing Web Application Queries a Database Hosted on an Amazon

question 193

Multiple Choice

A public-facing web application queries a database hosted on an Amazon EC2 instance in a private subnet. A large number of queries involve multiple table joins, and the application performance has been degrading due to an increase in complex queries. The application team will be performing updates to improve performance. What should a solutions architect recommend to the application team? (Choose two.)

• A) Cache query data in Amazon SQS
• B) Create a read replica to offload queries
• C) Migrate the database to Amazon Athena
• D) Implement Amazon DynamoDB Accelerator to cache data.
• E) Migrate the database to Amazon RDS

---

Definitions:

Plantations

Large farms specialized in the production of one or more cash crops, often operated with a labor-intensive approach.

Substitutes

Goods or services that can be used in place of each other, where an increase in the price of one leads to an increase in demand for the other.

Expedited Shipping

A shipping option that ensures faster delivery than standard shipping methods.

Controllable Factor

Something that affects demand that a company can change. Examples include price, advertising, warranties, and product quality.