Q60 — AWS SAA-C03 Ch.12

Question 60 of 100 | ← Chapter 12

Q860. A company is migrating a three-tier application to AWS. The application requires a MySQL database. In the past, the application users reported poor application performance when creating new entries. These performance issues were caused by users generating different real-time reports from the application during working hours.Which solution will improve the performance of the application when it is moved to AWS?

Correct Answer: C. Create an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas. Configure the application to use the reader endpoint for reports.

Explanation

To improve the performance of the application when migrating it to AWS and addressing the poor application performance during real-time report generation, the recommended solution is:C. Create an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas. Configure the application to use the reader endpoint for reports.Here's why:Option C suggests creating an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas. This solution provides scalability and high availability for the MySQL database while improving the performance of the application during report generation.By using an Aurora Multi-AZ DB cluster, you benefit from the underlying distributed architecture that replicates data across multiple Availability Zones (AZs) for durability and fault tolerance. By adding read replicas to the cluster, you can offload read traffic from the primary instance and distribute the workload across multiple instances, improving both read performance and scalability.Configuring the application to use the reader endpoint for reports allows the application to leverage the read replicas for report generation. This helps to alleviate the load on the primary instance and improves the overall performance of the application during working hours when multiple users generate real-time reports.Option A suggests importing the data into an Amazon DynamoDB table with provisioned capacity and refactoring the application to use DynamoDB for reports. While DynamoDB offers high scalability and performance for certain workloads, it may not be the most suitable solution for a MySQL database migration. DynamoDB has different data modeling and query patterns compared to a traditional relational database like MySQL, which would require significant application modifications and may not be ideal for a seamless migration.Option B suggests creating the database on a compute-optimized Amazon EC2 instance with compute resources exceeding the on-premises database. While this option provides control over the compute resources, it does not address the scalability and high availability requirements, nor does it take advantage of managed database services available in AWS.Option D suggests creating an Amazon Aurora MySQL Multi-AZ DB cluster and configuring the application to use the backup instance of the cluster as an endpoint for reports. This option does not utilize the read replicas available in the Aurora Multi-AZ DB cluster, which limits the scalability and performance benefits that can be achieved.In summary, the recommended solution is to create an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas and configure the application to use the reader endpoint for reports. This solution provides scalability, high availability, and improved performance for the application during real-time report generation.