nerdexam
Amazon

PAS-C01 · Question #15

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

The correct answer is D. Cold HDD (sc1). Cold HDD (sc1) is the most cost-effective EBS volume type and is well-suited for this use case. The workload is writing SQL Server database backups sequentially to a temporary staging volume before transferring them to S3 - this is an infrequently accessed, throughput-oriented…

Design of SAP Workloads on AWS

Question

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?

Options

  • AThroughput Optimized HDD (st1)
  • BProvisioned IOPS SSD (io2)
  • CGeneral Purpose SSD (gp3)
  • DCold HDD (sc1)

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    15% (6)
  • D
    75% (30)

Explanation

Cold HDD (sc1) is the most cost-effective EBS volume type and is well-suited for this use case. The workload is writing SQL Server database backups sequentially to a temporary staging volume before transferring them to S3 - this is an infrequently accessed, throughput-oriented (not IOPS-intensive) workload. sc1 has the lowest per-GB cost of all EBS volume types and supports sufficient throughput for sequential backup writes. Throughput Optimized HDD (st1, option A) is similar but more expensive than sc1 and better suited for frequently accessed streaming workloads. General Purpose SSD (gp3, option C) and Provisioned IOPS SSD (io2, option B) are significantly more expensive and provide unnecessary random-access IOPS performance for a sequential backup staging use case.

Topics

#EBS volume types#Storage cost optimization#SQL Server backups#SAP on AWS storage

Community Discussion

No community discussion yet for this question.

Full PAS-C01 Practice