Answer-first summary for fast verification
Answer: Use the Performance Insights feature of Amazon RDS to identify queries that have high CPU utilization. Optimize the problematic queries., Upgrade to a larger instance size.
Option A is CORRECT because using the Performance Insights feature of Amazon RDS to identify queries that have high CPU utilization and optimizing the problematic queries can significantly reduce CPU load. This helps to pinpoint and address inefficient queries that contribute to high CPU usage. Option D is CORRECT because upgrading to a larger instance size provides more CPU resources, which can help handle the high write workload and reduce CPU utilization, thereby improving overall database performance.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 39/60
A company uses Amazon RDS for MySQL as the database for a critical application. The database workload is mostly writes, with a small number of reads.
A data engineer notices that the CPU utilization of the DB instance is very high. The high CPU utilization is slowing down the application. The data engineer must reduce the CPU utilization of the DB Instance.
Which actions should the data engineer take to meet this requirement? (Choose two.)
A
Use the Performance Insights feature of Amazon RDS to identify queries that have high CPU utilization. Optimize the problematic queries.
B
Modify the database schema to include additional tables and indexes.
C
Reboot the RDS DB instance once each week.
D
Upgrade to a larger instance size.
E
Implement caching to reduce the database query load.
No comments yet.