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.
Correct Answer:
Verified
Q222: A company is developing a new machine
Q223: A company is selling up an application
Q224: A company has 700 TB of backup
Q225: A company stores call recordings on a
Q226: A company previously migrated its data warehouse
Q228: A company is preparing to launch a
Q229: A company has a custom application with
Q230: A company has a three-tier environment on
Q231: A company's order fulfillment service uses a
Q232: A solutions architect is planning the deployment
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents