A solution architect is migrating an enterprise Oracle database to local SSD-backed EC2 instances requiring high random I/O performance and high IOPS. Which EC2 instance type would be appropriate for this scenario?

Answer options:

A.i3.xlarge
B.p3.2xlarge
C.c5.2xlarge
D.db.t3.large

Answer: A
Option A is CORRECT because the I family EC2 instance type provides SSD-backed instance storage optimized for low latency, high random I/O performance, and high IOPS performance.
Option B is incorrect because the P family EC2 instance type is general-purpose GPU instances.Additionally, p3.2xlarge is an EBS backed instance type.
Option C is incorrect because c5.xlarge is EBS backed compute-intensive workload EC2 instance type.
Option D is incorrect because this is not an EC2 instance type, but an RDS DB instance class.Also, the T family is EBS backed general purpose instance type.
If an instance type supports both EBS backed and local NVMe-based SSD storage, a quick method to identify if it is an SSD-backed EC2 type is to check if the identifier has a “d” in its name (e.g. “c5” vs “c5d”).
Reference:
https://aws.amazon.com/ec2/instance-types/
https://docs.aws.amazon.com/whitepapers/latest/oracle-database-aws-best-practices/amazon-ec2-instance-type.html