A company plans to migrate its SAP ERP system from an on-premises environment to AWS. The system uses an Oracle database. Which AWS service provides the most cost-effective and high-performance storage for the Oracle data files?
Provides high performance for databases.
Why this answer
Amazon EBS io2 Block Express volumes provide the highest performance and durability for Oracle database workloads on AWS, offering up to 256,000 IOPS per volume and sub-millisecond latency. They are the most cost-effective choice for SAP ERP Oracle data files because they deliver consistent, high-throughput performance required for SAP's demanding I/O patterns, while allowing you to pay only for provisioned capacity without upfront costs. io2 volumes also support multi-attach and are designed for mission-critical databases, making them the optimal storage for Oracle data files in SAP on AWS.
Exam trap
The trap here is that candidates often confuse Amazon EFS or S3 as viable database storage options due to their scalability and durability, but they fail to recognize that Oracle databases require block-level storage with consistent low latency and high IOPS, which only EBS io2 Block Express provides for SAP workloads.
How to eliminate wrong answers
Option B (EC2 Instance Store) is wrong because instance store volumes are ephemeral and data is lost when the instance is stopped or terminated, making them unsuitable for persistent Oracle database storage. Option C (Amazon EFS) is wrong because it is a file-level NFS storage service that does not provide the block-level access or consistent low-latency performance required for Oracle database data files, and it is not optimized for high IOPS database workloads. Option D (Amazon S3) is wrong because it is an object storage service with higher latency and no direct block-level access, making it unsuitable for hosting live Oracle database files that require synchronous I/O operations.