DBS-C01 · Question #127
A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for…
The correct answer is D. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS. Chance of 60 second downtime due to change in instance class but performance improvement over CPU and storage.
Question
A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi-AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance. Which approach should the database specialist to take to resolve this issue without changing the application?
Options
- AImplementing sharding to distribute the load to multiple RDS for MySQL databases.
- BUse the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
- CAdd an RDS for MySQL read replica.
- DModify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS
How the community answered
(37 responses)- A3% (1)
- B22% (8)
- C8% (3)
- D68% (25)
Explanation
Chance of 60 second downtime due to change in instance class but performance improvement over CPU and storage.
Topics
Community Discussion
No community discussion yet for this question.