ExpertMedium1 markMultiple Choice
AWS SAP-C02 · Question 62 · Domain 3.3: Performance Improvement
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)
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:
A.
Implement Amazon ElastiCache to cache frequent query results.
B.
Create RDS Read Replicas and offload read traffic to them.
C.
Optimize the database schema and add appropriate indexes.
D.
Enable Multi-AZ on the RDS instance.
E.
Migrate the database to Amazon DynamoDB.
F.
Use AWS Global Accelerator.
How to approach this question
Select standard database performance optimization techniques.
Full Answer
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).
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...HardQ02A company uses AWS Organizations. The CISO requires that no EC2 instances can be launched outside...MediumQ03An application uses Amazon Aurora PostgreSQL. To meet disaster recovery requirements, the databas...HardQ04A company is setting up a new multi-account AWS environment. They want to automate the creation o...MediumQ05An organization wants to allocate AWS costs to specific departments. They use multiple AWS accoun...Medium