AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ48

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