Q88 — AWS SAA-C03 Ch.12

Question 88 of 100 | ← Chapter 12

Q888. A company that runs its application on AWS uses an Amazon Aurora DB cluster as its database. During peak usage hours when multiple users access and read the data, the monitoring system shows degradation of database performance for the write queries. The company wants to increase the scalability of the application to meet peak usage demands.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: C. Create an Aurora read replica in the existing Aurora DB cluster. Update the application to use the replica endpoint for read-only queries and to use the cluster endpoint for write queries.

Explanation

To increase the scalability of the application and meet peak usage demands in a cost-effective manner, the following solution can be implemented:C. Create an Aurora read replica in the existing Aurora DB cluster. Update the application to use the replica endpoint for read-only queries and to use the cluster endpoint for write queries.Amazon Aurora provides the capability to create read replicas within an Aurora DB cluster. By creating a read replica in the existing Aurora DB cluster, the company can offload read traffic from the primary instance to the replica, increasing the overall scalability of the application. The read replica can handle read-only queries, reducing the load on the primary instance and improving the performance of write queries during peak usage hours.The application can be updated to direct read-only queries to the replica endpoint, while write queries can continue to be directed to the cluster endpoint. This ensures that read traffic is distributed to the read replica, while write traffic goes to the primary instance.Option A suggests creating a second Aurora DB cluster and configuring a copy job to replicate the users' data to the new database. While this approach can provide scalability by distributing the read traffic, it involves additional complexity and cost associated with managing and maintaining a separate DB cluster and data replication.Option B suggests creating an Amazon DynamoDB Accelerator (DAX) cluster in front of the existing Aurora DB cluster. While DAX can improve read performance by caching frequently accessed data, it does not directly address the scalability of write queries. Additionally, introducing DAX adds an additional cost factor.Option D suggests creating an Amazon Redshift cluster and copying the users' data to it. While Redshift is a powerful data warehousing solution, it is primarily designed for analytics and reporting rather than serving as an operational database. Using Redshift for read-only queries introduces data replication overhead and may not provide the desired performance improvement for write queries.In summary, to meet the requirements of increasing scalability and handling peak usage demands in a cost-effective manner, creating an Aurora read replica in the existing Aurora DB cluster and updating the application to direct read-only queries to the replica endpoint (Option C) is the most suitable solution.