An Online Shopping Application Accesses an Amazon RDS Multi-AZ DB

question 324

Multiple Choice

An online shopping application accesses an Amazon RDS Multi-AZ DB instance. Database performance is slowing down the application. After upgrading to the next-generation instance type, there was no significant performance improvement. Analysis shows approximately 700 IOPS are sustained, common queries run for long durations and memory utilization is high. Which application change should a solutions architect recommend to resolve these issues?

• A) Migrate the RDS instance to an Amazon Redshift cluster and enable weekly garbage collection.
• B) Separate the long-running queries into a new Multi-AZ RDS database and modify the application to query whichever database is needed.
• C) Deploy a two-node Amazon ElastiCache cluster and modify the application to query the cluster first and query the database only if needed.
• D) Create an Amazon Simple Queue Service (Amazon SQS) FIFO queue for common queries and query it first and query the database only if needed.

---

Definitions:

Double Covalent Bonds

Chemical bonds where two pairs of electrons are shared between atoms, resulting in a stronger and more stable bond than a single covalent bond.

Carbohydrates

Organic compounds consisting of carbon, hydrogen, and oxygen, typically found in sugars, starches, and cellulose, serving as a major energy source in the diet of animals.

Starches

Complex carbohydrates that are composed of many glucose units joined together, found in foods like potatoes, rice, and wheat.

Energy Nutrients

Nutrients such as carbohydrates, fats, and proteins that provide energy for the body to perform its functions.