Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 117 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 117
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi-AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.
Which approach should the database specialist take to resolve this issue without changing the application?

A. Implement sharding to distribute the load to multiple RDS for MySQL databases.
B. Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
C. Add an RDS for MySQL read replica.
D. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).

Show Suggested Answer

Suggested Answer: D 🗳️

by shantest1 at April 8, 2021, 2:49 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

Scunningham99

Highly Voted 3 years, 7 months ago

I would go with D due to the high cpu utilisation; not C as this would require app to use read endpoint - therefore app change required

upvoted 15 times

...

redman50

Most Recent 2 years, 2 months ago

Selected Answer: B

The high read latency and high CPU utilization on the Amazon RDS for MySQL Multi-AZ DB instance can be addressed by using Provisioned IOPS (PIOPS) storage with the same RDS for MySQL instance class. Therefore, option B is the correct approach to resolve the issue without changing the application. By using Provisioned IOPS (PIOPS), the database can deliver predictable and consistent I/O performance, which helps improve read latency and CPU utilization.

upvoted 1 times

synthia2

2 years, 1 month ago

Multi-AZ is not for performance.

upvoted 1 times

...

saikirankshatriya

2 years, 6 months ago

Selected Answer: D

B - doesnt incur downtime can change and improve performance but on the storage front C - Needs to send high load queries to replicas D - Chance of 60 second downtime due to change in instance class but performance improvement over CPU and storage.

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: D

x C. Add an RDS for MySQL read replica. (Would need program to use Read End Point, else it is good solution) D. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS). (because of high CPU + no change in code)

upvoted 2 times

...

RotterDam

3 years, 3 months ago

CPU Utilization is High - This means the Database is underprovisioned - this drives the overall strategy to remediate the Instance class. (D) is the only option

upvoted 3 times

...

deepcloud

3 years, 5 months ago

"without requiring program to be changed" - Adding read replica will need program to be changed to add replica endpoint. D should be the answer

upvoted 3 times

...

Amy2009

3 years, 7 months ago

B should be the answer

upvoted 1 times

...

patricpotter1992

3 years, 7 months ago

Correct Answer Should be D because of "Which approach should the database specialist to take to resolve this issue without changing the application?" WITHOUT CHANGING THE APPLICATION. Option C would need add the read-endpoints to the application.

upvoted 4 times

...

ChauPhan

3 years, 8 months ago

After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance. => C. Add read replicas for read SQL.

upvoted 1 times

...

sbhujbal

3 years, 8 months ago

option c is out since "The site performs a high number of repetitive reads and writes". So mostly Option D is correct

upvoted 1 times

ChauPhan

3 years, 7 months ago

After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance

upvoted 2 times

...

AM

3 years, 8 months ago

The only issue with C is that the application needs to be changed to point read traffic to read replica. This is not allowed as per the question. In that case the instance size increase will take care of the high CPU utilization. PIOPS will be bonus (As per the option D). I will go with option D.

upvoted 3 times

...

Aesthet

3 years, 8 months ago

Both C and D will do the job. "to resolve this issue without changing the application" - with C you have at least balance some or all reads across master and replica, add a connection string to read replica. So this makes D a correct answer (even though I prefer answer C over D if not that formulation).

upvoted 3 times

...