Q53 — AWS SAA-C03 Ch.13

Question 53 of 100 | ← Chapter 13

Q953. A company is migrating a production environment application to the AWS Cloud.The company uses Amazon RDS for Oracle for the database layer. The company needs to configure the database to meet the needs of high l/O intensive workloads that require low latency and consistent throughput. The database workloads are read intensive and write intensive.Which solution will meet these requirements?

Correct Answer: B. Configure the RDS for Oracle database to use the Provisioned IOPS SSD storage type

Explanation

The best solution to meet the requirements of high I/O intensive workloads with low latency and consistent throughput is B. Configure the RDS for Oracle database to use the Provisioned IOPS SSD storage type.Here's why:Provisioned IOPS: Provisioned IOPS (input/output operations per second) storage provides predictable and consistent performance for high-demand workloads. It allows you to specify the desired IOPS level, ensuring consistent performance even under heavy load.Low Latency: SSD storage is significantly faster than magnetic storage, resulting in lower latency for read and write operations.Read and Write Intensive: Provisioned IOPS SSD storage is designed to handle both read and write- intensive workloads efficiently.Why other options are less suitable:A. Use a Multi-AZ DB instance deployment for the RDS for Oracle database: Multi-AZ deployment provides high availability but doesn't directly address the need for high I/O performance. C. Configure the RDS for Oracle database to use the General Purpose SSD storage type: General Purpose SSD storage is a good option for general-purpose workloads but doesn't offer the same level of performance as Provisioned IOPS SSD storage.D. Enable RDS read replicas for RDS for Oracle: Read replicas are used for read-only workloads and don't improve the performance of the primary database for write operations.In summary:Option B provides the most effective solution for meeting the performance requirements of the high I/O intensive workloads. Provisioned IOPS SSD storage ensures consistent performance, low latency, and the ability to handle both read and write-intensive operations effectively.