Deal of The Day! 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 7 Question 87 Discussion

Actual exam question for Amazon's DBS-C01 exam
Question #: 87
Topic #: 7
[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 Marge at Mar 09, 2024, 03:46 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Caitlin
8 months ago
That's a good point, Throughput Optimized HDD could provide the necessary performance at a lower cost.
upvoted 0 times
...
Odette
8 months ago
I think Throughput Optimized hard disk drives (HDD) could also be a good option for this type of workload.
upvoted 0 times
...
Jerry
8 months ago
But wouldn't Provisioned IOPS storage be more expensive compared to General Purpose SSD storage?
upvoted 0 times
...
Dean
8 months ago
I disagree, I think Provisioned IOPS storage would be more suitable for the nightly batch processing.
upvoted 0 times
...
Caitlin
8 months ago
I believe General Purpose SSD storage would be the best option for this scenario.
upvoted 0 times
...
Jerry
8 months ago
I think we should choose the most cost-effective RDS storage option for migrating the database.
upvoted 0 times
...
Willard
9 months ago
Because it has lower cost compared to SSD and still provides decent performance for batch processing.
upvoted 0 times
...
Flo
9 months ago
Why do you think Magnetic storage would be better?
upvoted 0 times
...
Willard
9 months ago
I disagree. I think Magnetic storage could be more cost-effective for this scenario.
upvoted 0 times
...
Celestina
10 months ago
That's a good point. It might be worth the extra cost for better performance.
upvoted 0 times
...
Flo
10 months ago
But wouldn't Provisioned IOPS storage be better for high throughput batch processing?
upvoted 0 times
...
Celestina
10 months ago
I think the best option would be General Purpose SSD storage.
upvoted 0 times
...
Cheryll
11 months ago
Definitely, the Throughput Optimized HDD seems like the way to go. It should provide enough performance for the batch processing without breaking the bank. Although, I do wonder how much Amazon charges for their 'Bulk Discount' on hard drives - maybe we should look into that.
upvoted 0 times
...
Virgilio
11 months ago
Yeah, I agree. Provisioned IOPS is probably too much for a nightly batch processing workload. I'd be leaning towards the Throughput Optimized HDD option as the most cost-effective choice here.
upvoted 0 times
Dorethea
10 months ago
F: Throughput Optimized HDD sounds like a cost-effective solution for this scenario.
upvoted 0 times
...
Virgie
10 months ago
E: Provisioned IOPS storage might be overkill for nightly batch processing.
upvoted 0 times
...
Eve
10 months ago
D: I think Magnetic storage might not be the best choice for this workload.
upvoted 0 times
...
Lacey
10 months ago
C: Throughput Optimized HDD might provide better performance for batch processing.
upvoted 0 times
...
Kaitlyn
10 months ago
B: I agree, General Purpose SSD storage could be a good option too.
upvoted 0 times
...
Lachelle
10 months ago
A: I think General Purpose SSD storage could also work well for this.
upvoted 0 times
...
...
Stephane
11 months ago
You're right, the performance needs are key here. I'm thinking either Provisioned IOPS or Throughput Optimized HDD could work, but Provisioned IOPS might be overkill and more expensive than necessary.
upvoted 0 times
...
Lenita
11 months ago
Hmm, this is a tricky one. The database is 4 TB and primarily used for nightly batch processing, so I'd say we need to look at the performance requirements more than just the storage size.
upvoted 0 times
...

Save Cancel