An organization runs a critical application using Amazon RDS for MySQL. The workload is write-heavy with few reads. The DB instance shows very high CPU usage, which is degrading application performance. What steps should the data engineer take to lower the DB instance CPU utilization? (Choose two.)

High CPU utilization on an Amazon RDS for MySQL instance, especially with a write-heavy workload, often points to inefficient queries or insufficient resources. Performance Insights is a powerful tool for identifying the specific SQL queries consuming the most CPU, allowing a data engineer to optimize them. Query optimization, such as adding appropriate indexes or rewriting inefficient SQL, directly reduces the CPU load. If query optimization isn't enough or immediately feasible, upgrading to a larger instance size provides more CPU cores and memory, directly increasing the processing capacity and reducing CPU utilization. Modifying the database schema to include additional tables and indexes is a form of query optimization, but simply adding them without identifying problematic queries first can be counterproductive or not address the root cause. Rebooting the instance weekly is a temporary workaround that doesn't solve the underlying performance issue. Implementing caching is effective for read-heavy workloads but less impactful for write-heavy scenarios where the bottleneck is often the write operations themselves.