MENU
A company is running SAP ERP Central Component (SAP ECC) with a Microsoft SQL Server database on AWS A solutions architect must attach an additional 1 TB Amazon Elastic Block Store (Amazon EBS) volume. The company needs to write the SQL Server database backups to this EBS volume before moving the database backups to Amazon S3 for long-term storage.
Which EBS volume type will meet these requirements MOST cost-effectively?
Suggested Answer: A
Get Premium PAS-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
'For SQL Server database backup, you can use one of the following methods: SQL native tools to take backup on disk: Backup requires high throughput compared to IOPS. We recommend using Throughput Optimized HDD (st1) which provides maximum throughput of 500 MB/s per volume.'
32 comments · newest first
CA
Cammy
11 months ago
Provisioned IOPS SSD (io3) is overkill for just backups, though.
DI
Dierdre
11 months ago
Surprised that st1 is even an option for backups, isn’t it risky?
MU
Murray
11 months ago
Cold HDD (sc1) seems too slow for backups, right?
VI
Vicki
11 months ago
I disagree, I’d go with General Purpose SSD (gp3) for better performance.
SA
Sage
12 months ago
I think the Throughput Optimized HDD (st1) is the best choice for cost-effectiveness.
IS
Isabella
12 months ago
Cold HDD seems too slow for backups, but I can't recall if it's the cheapest option. I think it might be worth considering for infrequent access.
BE
Bernardine
1 year ago
I feel like Throughput Optimized HDD could be the most cost-effective choice here since backups don't need super high IOPS, right?
FI
Fidelia
1 year ago
I practiced a similar question where we had to choose between EBS types for a database. I think the Provisioned IOPS SSD could be overkill for just backups, though.
TE
Teri
1 year ago
I remember that for database backups, we usually want something that balances cost and performance. I think the General Purpose SSD might be a good option, but I'm not entirely sure.
JU
Jules
1 year ago
I'm pretty confident that the Throughput Optimized HDD (st1) would be the most cost-effective option here. The database backups don't require high IOPS, and the st1 volume type is designed for throughput-intensive workloads like this.
CH
Chandra
1 year ago
Okay, I think I've got this. Since we need to write database backups to the EBS volume, we'll want a volume type that can handle the throughput requirements cost-effectively. Based on that, I'd say option C, General Purpose SSD (gp3), is likely the best choice.
TA
Tamar
1 year ago
Hmm, I'm a bit unsure about this one. I know we need to consider factors like throughput, IOPS, and cost, but I'm not sure which volume type would be the best fit. I'll have to review the EBS volume specs carefully.
CH
Chauncey
1 year ago
This seems like a straightforward question about choosing the most cost-effective EBS volume type for the given requirements. I'll need to compare the performance and pricing of the different options.
GE
Gerardo
1 year ago
I'll eliminate the obviously incorrect answers first - like the one saying CCPs aren't regulated. That doesn't make sense for a healthcare program.
LA
Lashaunda
2 years ago
D) Cold HDD (sc1) seems like the most economical choice here. Who needs fast backups when you can just wait all day for them to finish?
GA
Gabriele
2 years ago
Hah! The company should just use floppy disks. That's the most cost-effective storage solution I can think of.
MA
Mabel
2 years ago
Rutha: D) Cold HDD (sc1)
LA
Latanya
2 years ago
User 3: C) General Purpose SSD (gp3)
RU
Rutha
2 years ago
User 2: B) Provisioned IOPS SSD (io3)
SA
Sabra
2 years ago
User 1: A) Throughput Optimized HDD (st1)
CE
Cecil
2 years ago
B) Provisioned IOPS SSD (io3) would be my pick. It's designed for high-performance database workloads, and the company needs to write the backups quickly before moving them to S3.
JA
Jani
2 years ago
A: Definitely, we need to ensure efficient backup processes for the SQL Server database on AWS.
LI
Lindsey
2 years ago
B: Yeah, it's important to have fast write speeds for the backups before moving them to Amazon S3.
TA
Tammi
2 years ago
A: I agree, Provisioned IOPS SSD (io3) is the best choice for high-performance database workloads.
AL
Alfreda
2 years ago
I think the correct answer is C) General Purpose SSD (gp3). It's a good balance between performance and cost for storing database backups.
PE
Percy
2 years ago
D: Yeah, gp3 makes sense for this use case. It should meet the requirements without breaking the bank.
OT
Otis
2 years ago
C: I would go with gp3 as well, it seems like the best choice for writing SQL Server database backups.
AZ
Azzie
2 years ago
B: I agree, gp3 sounds like the most cost-effective option for this scenario.
SH
Sherron
2 years ago
A: I think the correct answer is C) General Purpose SSD (gp3). It's a good balance between performance and cost for storing database backups.
YA
Yaeko
2 years ago
That's a good point, but I still think Provisioned IOPS SSD (io3) would provide better performance overall.
ER
Ernie
2 years ago
I disagree, I believe Throughput Optimized HDD (st1) would be more cost-effective for writing backups before moving them to Amazon S3.
YA
Yaeko
2 years ago
I think the best option would be Provisioned IOPS SSD (io3) because it offers high performance for database backups.