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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 61
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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

Suggested Answer: AD 🗳️

by damaldon at March 7, 2024, 9:57 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

kj07

Highly Voted 1 year, 3 months ago

Here the issue is with the writes and caching will not solve them. I will go with A and D.

upvoted 10 times

...

lucas_rfsb

Highly Voted 1 year, 2 months ago

Selected Answer: AD

I will go for A and D, since other options are more likely to improve read performance issues.

upvoted 9 times

...

michele_scar

Most Recent 7 months, 2 weeks ago

Selected Answer: AD

With A you should understand why the CPU is in high loading. B is mentioned in the last phrase of A (optimizing). Remain valid only D

upvoted 2 times

...

sdas1

1 year, 1 month 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

...

fceb2c1

1 year, 3 months ago

Selected Answer: AD

A and D. For A it is mentioned here https://repost.aws/knowledge-center/rds-instance-high-cpu

upvoted 5 times

...

GiorgioGss

1 year, 3 months 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 5 times

...

damaldon

1 year, 3 months 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 4 times

...