AWS Certified Data Engineer – Associate (DEA-C01) — Question 78

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.)

Answer options

• 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.

Correct answer: A, D

Explanation

Option A is correct because using Performance Insights allows the identification and optimization of resource-intensive queries, effectively reducing CPU usage. Option D is also correct since upgrading to a larger instance can provide more resources to handle the workload. Options B and E may help in specific scenarios but do not directly address the immediate high CPU utilization issue. Option C does not contribute to resolving the underlying CPU load problem.