Amazon Exam PAS-C01 Topic 4 Question 45 Discussion

Actual exam question for Amazon's PAS-C01 exam

Question #: 45
Topic #: 4

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?

AThroughput Optimized HDD (st1)

BProvisioned IOPS SSD (io3)

CGeneral Purpose SSD (gp3)

DCold HDD (sc1)

Show Suggested Answer

Suggested Answer: A

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

by Rodolfo at Sep 15, 2024, 07:03 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lashaunda

2 months 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?

upvoted 0 times

...

Gabriele

2 months ago

Hah! The company should just use floppy disks. That's the most cost-effective storage solution I can think of.

upvoted 0 times

Mabel

10 days ago

Rutha: D) Cold HDD (sc1)

upvoted 0 times

...

Latanya

12 days ago

User 3: C) General Purpose SSD (gp3)

upvoted 0 times

...

Rutha

16 days ago

User 2: B) Provisioned IOPS SSD (io3)

upvoted 0 times

...

Sabra

22 days ago

User 1: A) Throughput Optimized HDD (st1)

upvoted 0 times

...

Cecil

2 months 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.

upvoted 0 times

Jani

1 months ago

A: Definitely, we need to ensure efficient backup processes for the SQL Server database on AWS.

upvoted 0 times

...

Lindsey

1 months ago

B: Yeah, it's important to have fast write speeds for the backups before moving them to Amazon S3.

upvoted 0 times

...

Tammi

2 months ago

A: I agree, Provisioned IOPS SSD (io3) is the best choice for high-performance database workloads.

upvoted 0 times

...

Alfreda

2 months 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.

upvoted 0 times

Percy

1 months ago

D: Yeah, gp3 makes sense for this use case. It should meet the requirements without breaking the bank.

upvoted 0 times

...

Otis

1 months ago

C: I would go with gp3 as well, it seems like the best choice for writing SQL Server database backups.

upvoted 0 times

...

Azzie

2 months ago

B: I agree, gp3 sounds like the most cost-effective option for this scenario.

upvoted 0 times

...

Sherron

2 months 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.

upvoted 0 times

...

Yaeko

3 months ago

That's a good point, but I still think Provisioned IOPS SSD (io3) would provide better performance overall.

upvoted 0 times

...

Ernie

3 months ago

I disagree, I believe Throughput Optimized HDD (st1) would be more cost-effective for writing backups before moving them to Amazon S3.

upvoted 0 times

...

Yaeko

3 months ago

I think the best option would be Provisioned IOPS SSD (io3) because it offers high performance for database backups.

upvoted 0 times

...