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

C, AURORA is 5x performance improvement over MySQL on RDS and handles more read requests than write,; maintaining high availability = Multi-AZ deployment

Option C, using Amazon Aurora with a Multi-AZ deployment and configuring Aurora Auto Scaling with Aurora Replicas, would be the best solution to meet the requirements. Aurora is a fully managed, MySQL-compatible relational database that is designed for high performance and high availability. Aurora Multi-AZ deployments automatically maintain a synchronous standby replica in a different Availability Zone to provide high availability. Additionally, Aurora Auto Scaling allows you to automatically scale the number of Aurora Replicas in response to read workloads, allowing you to meet the demand of unpredictable read workloads while maintaining high availability. This would provide an automated solution for scaling the database to meet the demand of the application while maintaining high availability.

CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

Ans C. Its the only one that offers right level of scaling and availability

Here's why C is the best solution: Amazon Aurora: A managed, high-performance MySQL-compatible relational database engine. Multi-AZ deployment: Ensures high availability in case of an AZ failure. Aurora Auto Scaling with Aurora Replicas: Automatically scales read replicas based on traffic, improving read performance.

Answer-c

key statement: "...will automatically scale the database to meet the demand of unpredictable read workloads while maintaining high availability.

Aurora

C fit perfectly

Unpredictable read workloads while maintaining high availability = Amazon Aurora with a Multi-AZ deployment, Auto Scaling with Aurora read replicas.

As the application handles more read requests than write transactions, using read replicas with Aurora is an ideal choice as it allows read scaling without sacrificing write performance on the primary instance.

Option C MET THE REQUIREMENT

Option C

Option C: Using Amazon Aurora with a Multi-AZ deployment and configuring Aurora Auto Scaling with Aurora Replicas is the most appropriate solution. Aurora is a MySQL-compatible relational database engine that provides high performance and scalability. With Multi-AZ deployment, the database is automatically replicated across multiple Availability Zones for high availability. Aurora Auto Scaling allows the database to automatically add or remove Aurora Replicas based on the workload, ensuring that read requests can be distributed effectively and the database can scale to meet demand. This provides both high availability and automatic scaling to handle unpredictable read workloads.

C meets the requirements.

C Aurora with read replicas

Key words: - Must support MySQL - High Availability (must be mulit-az) - Auto Scaling