Q38 — AWS SAA-C03 Ch.13

Question 38 of 100 | ← Chapter 13

Q938. A company recently performed a lift and shift migration of its on-premises Oracle database workload to run on an Amazon EC2 memory optimized Linux instance.The EC2 Linux instance uses a 1 TB Provisioned IOPS SSD (io1) EBS volume with 64,000 IOPS.The database storage performance after the migration is slower than the performance of the on-premises database.Which solution will improve storage performance?

Correct Answer: A. Add more Provisioned IOPS SSD (io1)EBS volumes. Use OS commands to create a Logical Volume Management(LVM) stripe.

Explanation

The solution that will improve storage performance is:A. Add more Provisioned IOPS SSD (io1) EBS volumes. Use OS commands to create a Logical Volume Management(LVM) stripe.Here's why:Increased IOPS: Adding more io1 volumes effectively increases the overall IOPS available to the database, improving performance.LVM Stripe: Creating an LVM stripe across multiple volumes allows the database to access data from multiple drives simultaneously, further enhancing performance.Scalability: This approach provides a scalable solution for increasing storage capacity and IOPS as needed.Why other options are less effective:B. Increase the Provisioned IOPS SSD (io1) EBS volume to more than 64,000 IOPS. While increasing IOPS can help, it's limited by the maximum IOPS supported by a single io1 volume. Adding more volumes provides a more scalable solution.C. Increase the size of the Provisioned IOPS SSD (io1) EBS volume to 2 TB. Increasing the volume size doesn't necessarily improve IOPS performance. It primarily increases the storage capacity.D. Change the EC2 Linux instance to a storage optimized instance type. Do not change the Provisioned lOPS SSD (io1) EBS volume. Storage-optimized instances are designed for high throughput workloads, but they don't inherently increase the IOPS of the attached EBS volume.In summary:Option A provides the most effective solution for improving storage performance by increasing the overall IOPS available to the database through multiple io1 volumes and leveraging LVM striping for parallel access. This approach offers scalability and flexibility for future performance needs.