Best EBS Volume Type for Oracle Database Migration to EBS Backed EC2 Instances

Answer: B.

Option A is incorrect because gp2 volume type provides max IOPS of 16,000.

Option B is CORRECT because io1 volume type provides max IOPS of 64,000.

Option C is incorrect because st1 volume type provides 500 max IOPS performance.

Option D is incorrect because sc1 volume type provides 250 max IOPS performance.

Reference:

For an enterprise Oracle database requiring high I/O operations per second (IOPS), the appropriate EBS volume type would be io1.

io1 EBS volumes are designed to provide high-performance storage for critical applications that require high IOPS, high throughput, and low latency. They are ideal for workloads such as large databases, NoSQL databases, and data warehouses that require sustained I/O performance.

gp2 EBS volumes are general-purpose SSD volumes designed for a wide variety of workloads. They offer a baseline performance of 3 IOPS per GB and can burst up to 16,000 IOPS. However, they may not be able to provide sustained high I/O performance for critical applications.

st1 EBS volumes are designed for throughput-intensive workloads such as big data, log processing, and data warehousing. They offer low cost per GB and are optimized for sequential I/O performance, but they may not be suitable for random I/O workloads.

sc1 EBS volumes are designed for cold storage workloads and offer low cost per GB. They are optimized for sequential I/O performance and are suitable for infrequently accessed data that does not require high IOPS.

In summary, for an enterprise Oracle database requiring high IOPS, io1 EBS volumes are the appropriate choice.