An architect is optimizing a read-heavy web application backed by an Amazon RDS MySQL database. The database is experiencing high CPU utilization due to complex read queries. Which THREE strategies will improve performance? (Select THREE)

Answer options:

Implement Amazon ElastiCache to cache frequent query results.

Create RDS Read Replicas and offload read traffic to them.

Optimize the database schema and add appropriate indexes.

Enable Multi-AZ on the RDS instance.

Migrate the database to Amazon DynamoDB.

Use AWS Global Accelerator.

How to approach this question

Select standard database performance optimization techniques.

Full Answer

Implement Amazon ElastiCache to cache frequent query results., Create RDS Read Replicas and offload read traffic to them., Optimize the database schema and add appropriate indexes.

Caching, read replicas, and indexing are the three primary methods for optimizing a read-heavy relational database workload.

Common mistakes

Selecting Multi-AZ, thinking it provides read scaling (it only provides standby failover).

Question 61 All questions Question 63

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 3

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 100 VPCs across 5 AWS Regions. They need to establish a highly available, trans...Hard Q02A company uses AWS Organizations. The CISO requires that no EC2 instances can be launched outside...Medium Q03An application uses Amazon Aurora PostgreSQL. To meet disaster recovery requirements, the databas...Hard Q04A company is setting up a new multi-account AWS environment. They want to automate the creation o...Medium Q05An organization wants to allocate AWS costs to specific departments. They use multiple AWS accoun...Medium

View all 75 questions →