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 268 discussion

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

A company is using an Amazon RDS Multi-AZ DB instance in its development environment. The DB instance uses General Purpose SSD storage. The DB instance provides data to an application that has I/O constraints and high online transaction processing (OLTP) workloads. The users report that the application is slow.

A database specialist finds a high degree of latency in the database writes. The database specialist must decrease the database latency by designing a solution that minimizes operational overhead.

Which solution will meet these requirements?

  • A. Eliminate the Multi-AZ deployment. Run the DB instance in only one Availability Zone
  • B. Recreate the DB instance. Use the default storage type. Reload the data from an automatic snapshot
  • C. Switch the storage to Provisioned IOPS SSD on the DB instance that is running
  • D. Recreate the DB instance. Use Provisioned IOPS SSD storage. Reload the data from an automatic snapshot
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Sab at Dec. 5, 2022, 10:40 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

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
MultiAZ
1 year, 4 months ago
Selected Answer: C
C seems to be the answer. A can also help, especially for Dev. However, we do not have enough information to rule out the Multi-AZ. Also, the question does not mention price so C will do
upvoted 2 times
...
Pranava_GCP
1 year, 8 months ago
Selected Answer: C
C. Switch the storage to Provisioned IOPS SSD You can change the settings of a DB instance to accomplish tasks such as adding additional storage or changing the DB instance class. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html
upvoted 3 times
koki2847
1 year, 1 month ago
I agree with you. But be careful about what storage type your RDS instance migrates from or to. Any conversion between magnetic and SSD causes downtime according to the above website. It isn't applied to this case, though, just for your information.
upvoted 1 times
...
...
Mardoyyy
2 years, 5 months ago
Selected Answer: C
ans is C, changing from GP into privisoned IOPS does NOT make downtime and could apply immediately
upvoted 3 times
...
Mardoyyy
2 years, 5 months ago
ans is C, changing from GP into privisoned IOPS does NOT make downtime and could apply immediately
upvoted 2 times
...
catboy
2 years, 5 months ago
D right answer
upvoted 1 times
Sab
2 years, 5 months ago
Storage type can be modified. Storage type The storage type that you want to use. If you choose General Purpose SSD (gp3), you can provision additional Provisioned IOPS and Storage throughput under Advanced settings. If you choose Provisioned IOPS SSD (io1), enter the Provisioned IOPS value. After Amazon RDS begins to modify your DB instance to change the storage size or type, you can't submit another request to change the storage size, performance, or type for six hours. For more information, see Amazon RDS storage types https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html
upvoted 1 times
...
lollyj
2 years, 5 months ago
Answer C: I've tested and the storage and instance classes can be modified on the fly without downtime
upvoted 5 times
...
...
Sab
2 years, 5 months ago
Selected Answer: C
C You can modify storage class. There will be performance issue while storage is moved to new class.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago