Exam AWS Certified Database - Specialty topic 1 question 42 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 42
Topic #: 1

[All AWS Certified Database - Specialty Questions]

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?

A. Increase the size of the DB instance storage
B. Change the underlying EBS storage type to General Purpose SSD (gp2)
C. Disable EBS optimization on the DB instance
D. Change the DB instance to an instance class with a higher maximum bandwidth

Show Suggested Answer

Suggested Answer: D 🗳️

by learnaws at July 18, 2020, 6:27 a.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

BillyMadison

Highly Voted 3 years, 8 months ago

I think this is D https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html "If you are already using Provisioned IOPS storage, provision additional throughput capacity." Does D sound right?

upvoted 13 times

...

MultiAZ

Most Recent 1 year, 5 months ago

Selected Answer: D

Definitely D A will not help with the bottleneck, B and C will do things worse

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

Selected Answer: D

D. Change the DB instance to an instance class with a higher maximum bandwidth the performance issue in this case is not related to storage nor cpu nor RAM, it is related to network bandwidth.

upvoted 2 times

...

IhorK

1 year, 10 months ago

Selected Answer: D

We need to understand the difference between throughput and IOPS. IOPS – Count of read/write operations per second. Throughput – Count of read/write bits per second (bps). This measures the amount of time it takes for a disk to read and write data. Throughput is typically the best storage metric when measuring data that needs to be streamed rapidly, such as images and video files. So it's not about the size (A). Provisioned IOPS storage to General Purpose SSD (gp2) (B) - rather worse performance judging by data from https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-volume-types.html Disable EBS optimization (E) - rather, it should be activated, if there is such a thing. Instance class with a higher maximum bandwidth (D) - we have "uses all of its maximum bandwidth for read throughput" in the question. We need to choose another instance class with a higher bandwidth - D.

upvoted 1 times

...

lollyj

2 years, 6 months ago

Selected Answer: D

Correct answer I think

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: D

Objective is to handle maximum bandwidth for read throughput used x A. Increase the size of the DB instance storage (unrelated) x B. Change the underlying EBS storage type to General Purpose SSD (gp2) (will slow down) x C. Disable EBS optimization on the DB instance (will slow down) D. Change the DB instance to an instance class with a higher maximum bandwidth https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html

upvoted 2 times

...

kret

3 years, 2 months ago

Selected Answer: D

A. Increase the size of the DB instance storage - nonsense; instance is using EBS B. Change the underlying EBS storage type to General Purpose SSD (gp2) -> nonsense; GP2 is slower than IO2 C. Disable EBS optimization on the DB instance -> nonsense; nothing like this exist D is the answer

upvoted 3 times

...