exam questions

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 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 Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
BillyMadison
Highly Voted 3 years, 7 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, 3 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, 7 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, 8 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, 4 months ago
Selected Answer: D
Correct answer I think
upvoted 1 times
...
novice_expert
2 years, 11 months 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 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
...
guru_ji
3 years, 6 months ago
Correct Answer ==>> D
upvoted 1 times
...
LMax
3 years, 6 months ago
My answer is D
upvoted 1 times
...
myutran
3 years, 6 months ago
Ans: D
upvoted 1 times
...
RSSRAO
3 years, 6 months ago
Answer is D
upvoted 1 times
...
JobinAkaJoe
3 years, 6 months ago
D is the right answer
upvoted 1 times
...
Ashoks
3 years, 6 months ago
D. For high throughput.
upvoted 2 times
...
AWSCert2020
3 years, 6 months ago
D here! Throughput is related to Size/Type of Instance https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-optimized.html
upvoted 1 times
...
AWSCert2020
3 years, 6 months ago
Throughput is related to Size/Type of Instance https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-optimized.html
upvoted 1 times
...
BillyC
3 years, 6 months ago
Sorry i mean D
upvoted 2 times
...
BillyC
3 years, 7 months ago
Ans B here
upvoted 1 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago