BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Amazon Exam DBS-C01 Topic 3 Question 83 Discussion

Actual exam question for Amazon's DBS-C01 exam
Question #: 83
Topic #: 3
[All DBS-C01 Questions]

A database specialist is planning to migrate a 4 TB Microsoft SQL Server DB instance from on premises to Amazon RDS for SQL Server. The database is primarily used for nightly batch processing.

Which RDS storage option meets these requirements MOST cost-effectively?

Show Suggested Answer Hide Answer
Suggested Answer: A

General Purpose SSD storage is a cost-effective storage option that is ideal for a broad range of workloads running on medium-sized DB instances1.General Purpose storage is best suited for development and testing environments1.Since the database is primarily used for nightly batch processing, it does not require high I/O performance or low latency that Provisioned IOPS storage offers12.Magnetic storage and Throughput Optimized HDD are not recommended for new storage needs, and they have lower storage limits than General Purpose SSD and Provisioned IOPS SSD1. Therefore, General Purpose SSD storage meets the requirements most cost-effectively.


by Cherry at Dec 11, 2023, 03:24 AM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Veda
7 months ago
Haha, classic database dilemma - do you go for speed or do you go for savings? I'm with Darell on this one, General Purpose SSD seems like the sweet spot. You get decent performance without breaking the bank.
upvoted 0 times
Roslyn
6 months ago
I think we can all agree on that. It's a good compromise between speed and savings.
upvoted 0 times
...
Eve
7 months ago
In this case, I think General Purpose SSD storage would be the most cost-effective option.
upvoted 0 times
...
Myra
7 months ago
Exactly, finding the balance between performance and cost is key.
upvoted 0 times
...
Francine
7 months ago
I see your point, savings are also important when making such decisions.
upvoted 0 times
...
Owen
7 months ago
True, but it might be more costly compared to General Purpose SSD storage.
upvoted 0 times
...
Craig
7 months ago
But what about Provisioned IOPS storage? Wouldn't that ensure better performance for the nightly batch processing?
upvoted 0 times
...
Terrilyn
7 months ago
I agree, General Purpose SSD storage should be the right choice.
upvoted 0 times
...
...
Maira
7 months ago
Hold up, what about Throughput Optimized HDD? It's a lot cheaper than the SSD options, and for a mostly batch-oriented workload, the reduced IOPS might not be a big deal. Plus, you get a ton of storage for your money.
upvoted 0 times
...
Darell
7 months ago
I don't know, man. Provisioned IOPS is great, but it can get really expensive, especially for a 4 TB database. General Purpose SSD might be the way to go - it's a good balance of performance and cost-effectiveness.
upvoted 0 times
...
Chan
7 months ago
Hmm, this is an interesting one. A 4 TB database for batch processing definitely needs some serious storage horsepower. I'm leaning towards Provisioned IOPS storage - the consistent high performance should be perfect for those nightly batch jobs.
upvoted 0 times
...

Save Cancel