Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 919 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03

Question #: 919
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

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?

A. Add more Provisioned IOPS SSD (io1) EBS volumes. Use OS commands to create a Logical Volume Management (LVM) stripe.
B. Increase the Provisioned IOPS SSD (io1) EBS volume to more than 64,000 IOPS.
C. Increase the size of the Provisioned IOPS SSD (io1) EBS volume to 2 TB.
D. Change the EC2 Linux instance to a storage optimized instance type. Do not change the Provisioned IOPS SSD (io1) EBS volume.

Show Suggested Answer

Suggested Answer: A 🗳️

by pujithacg8 at Aug. 10, 2024, 6:28 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

FlyingHawk

5 months, 1 week ago

Selected Answer: A

https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-best-practices/striping.html

upvoted 2 times

FlyingHawk

5 months, 1 week ago

When the performance requirement cannot be met by a single EBS volume, consider striping using Logical Volume Management (LVM). For example, if a single volume has 250 MiB/s throughput capacity, having a stripe set across four volumes can deliver 1000 MiB/s throughput. Volumes should be of the same size and performance characteristics. https://docs.aws.amazon.com/wellarchitected/latest/sap-lens/best-practice-14-2.html

upvoted 2 times

...

LeonSauveterre

5 months, 3 weeks ago

Selected Answer: A

A - For example, given two io1 volumes, each provisioned with 64,000 IOPS, would provide a combined 128,000 IOPS. B - The maximum IOPS for an io1 volume is capped at 64,000 IOPS when attached to an EC2 instance. C - While increasing the size of the volume increases baseline throughput (3 IOPS per GB), it won’t exceed the 64,000 IOPS limit. D - Storage optimized instances (like i3 or i4i) use instance store volumes, which are ephemeral (non-persistent) and cannot be used as a replacement for durable EBS volumes in this use case. What is the deal with LVM striping? LVM striping allows multiple volumes to be treated as a single logical volume. Reads and writes are distributed across the striped volumes, effectively increasing the available IOPS and throughput beyond the single-volume limits.

upvoted 4 times

...

JA2018

6 months ago

Selected Answer: B

why I would choose Option B: - Issue: The problem is that the current IOPS (Input/Output Operations Per Second) provisioned on the EBS volume are not sufficient to meet the database workload demands, leading to slower performance compared to the on-premises setup. - Solution: Since the bottleneck is clearly identified as inadequate IOPS, the most effective solution is to simply increase the provisioned IOPS on the existing EBS volume, allowing for faster data read/write operations.

upvoted 1 times

...