ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 209 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 209
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads. The database has 5 ׀¢׀’ of storage space with Provisioned IOPS. Amazon CloudWatch metrics show that the average disk queue depth is greater than
200 and that the disk I/O response time is significantly higher than usual.
What should the database specialist do to improve the performance of the application immediately?

  • A. Increase the Provisioned IOPS rate on the storage.
  • B. Increase the available storage space.
  • C. Use General Purpose SSD (gp2) storage with burst credits.
  • D. Create a read replica to offload Read IOPS from the DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by mbar94 at Sept. 5, 2022, 6:26 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

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
Submit Cancel
PVM159
Highly Voted 1 year, 9 months ago
What is ׀¢׀’ in the question guys?
upvoted 5 times
zanhsieh
1 year, 5 months ago
TB. Google the answer text should reveal the original question somewhere.
upvoted 2 times
...
...
MultiAZ
Most Recent 12 months ago
Selected Answer: A
A Although it may still take some time to "rebalance" the storage
upvoted 2 times
...
lollyj
2 years ago
Selected Answer: A
Increasing the provisioned IO capacity will immediately alleviate the latency.
upvoted 3 times
...
parle101
2 years ago
Ans - A Getting the best performance from Amazon RDS Provisioned IOPS SSD storage: If your workload is I/O constrained, using Provisioned IOPS SSD storage can increase the number of I/O requests that the system can process concurrently. Increased concurrency allows for decreased latency because I/O requests spend less time in a queue. Decreased latency allows for faster database commits, which improves response time and allows for higher database throughput. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
upvoted 2 times
...
hogtrough
2 years, 2 months ago
Selected Answer: A
Key word is "immediate." Replica will take time to create.
upvoted 2 times
...
awsjjj
2 years, 2 months ago
Selected Answer: A
answer A due to "immediate improvement"
upvoted 1 times
...
cloudsunriser
2 years, 3 months ago
Selected Answer: A
I think both A and D are correct but as last line of question says we want immediate improvement then A should be answer as read replica creation will take some time.
upvoted 2 times
...
SonamDhingra
2 years, 4 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
mbar94
2 years, 4 months ago
Selected Answer: D
It seems that D - https://aws.amazon.com/blogs/database/best-storage-practices-for-running-production-workloads-on-hosted-databases-with-amazon-rds-or-amazon-ec2/
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago