Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 61 discussion

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.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
kj07
Highly Voted 3 months ago
Here the issue is with the writes and caching will not solve them. I will go with A and D.
upvoted 6 times
...
sdas1
Most Recent 1 month, 1 week ago
A and D With a workload that is mostly writes and a small number of reads, caching will not be as effective in reducing CPU utilization compared to read-heavy workloads. https://repost.aws/knowledge-center/rds-aurora-postgresql-high-cpu
upvoted 2 times
...
lucas_rfsb
2 months, 2 weeks ago
Selected Answer: AD
I will go for A and D, since other options are more likely to improve read performance issues.
upvoted 3 times
...
fceb2c1
2 months, 3 weeks ago
Selected Answer: AD
A and D. For A it is mentioned here https://repost.aws/knowledge-center/rds-instance-high-cpu
upvoted 3 times
...
GiorgioGss
2 months, 4 weeks ago
Selected Answer: BD
Since the questions states that "the database workload is mostly writes" let's eliminate the options that improves the reads.
upvoted 2 times
...
damaldon
3 months, 1 week ago
Ans. AE A) Use Amazon RDS Performance Insights to identify the query that's responsible for the database load. Check the SQL tab that corresponds to a particular timeframe. E) If there's a query that's repeatedly running, use prepared statements to lower the pressure on your CPU. Repeated running of prepared statements caches the query plan. Because the plan is already in cache for further runs, the time for planning is much less. https://repost.aws/knowledge-center/rds-aurora-postgresql-high-cpu
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...