QuestionQ48

VerifiedData Store Management

A company uses Amazon RDS for MySQL as the database for a critical application. The database workload consists mostly of writes, with only a small number of reads.

A data engineer observes that DB instance CPU utilization is very high. This high CPU utilization is slowing the application. The data engineer must reduce CPU utilization on the DB instance.

Which actions should the data engineer take to meet this requirement?

Choose two
Explanation

For an RDS DB instance with CPU overload, Performance Insights can identify SQL statements that create high CPU load, allowing those queries to be optimized. If CPU demand still exceeds the available vCPUs, using a larger DB instance class adds CPU capacity. Because the workload is mostly writes, caching the comparatively small read workload is unlikely to materially reduce database CPU utilization; additional indexes can also add write-processing overhead.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!