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

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

Submit Cancel

MultiAZ

1 year, 5 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, 10 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, 2 months 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, 6 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, 6 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, 7 months ago

D right answer

upvoted 1 times

Sab

2 years, 7 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, 6 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, 7 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

...