Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam

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

A company runs an ecommerce application on Amazon EC2 instances behind an Application Load Balancer. The instances run in an Amazon EC2 Auto Scaling group across multiple Availability Zones. The Auto Scaling group scales based on CPU utilization metrics. The ecommerce application stores the transaction data in a MySQL 8.0 database that is hosted on a large EC2 instance.
The database's performance degrades quickly as application load increases. The application handles more read requests than write transactions. The company wants a solution that will automatically scale the database to meet the demand of unpredictable read workloads while maintaining high availability.
Which solution will meet these requirements?

  • A. Use Amazon Redshift with a single node for leader and compute functionality.
  • B. Use Amazon RDS with a Single-AZ deployment Configure Amazon RDS to add reader instances in a different Availability Zone.
  • C. Use Amazon Aurora with a Multi-AZ deployment. Configure Aurora Auto Scaling with Aurora Replicas.
  • D. Use Amazon ElastiCache for Memcached with EC2 Spot Instances.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
D2w
Highly Voted 2 years ago
Selected Answer: C
C, AURORA is 5x performance improvement over MySQL on RDS and handles more read requests than write,; maintaining high availability = Multi-AZ deployment
upvoted 45 times
...
Buruguduystunstugudunstuy
Highly Voted 1 year, 9 months ago
Selected Answer: C
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.
upvoted 19 times
Buruguduystunstugudunstuy
1 year, 9 months ago
Option A, using Amazon Redshift with a single node for leader and compute functionality, would not provide high availability. Option B, using Amazon RDS with a Single-AZ deployment and configuring RDS to add reader instances in a different Availability Zone, would not provide high availability and would not automatically scale the number of reader instances in response to read workloads. Option D, using Amazon ElastiCache for Memcached with EC2 Spot Instances, would not provide a database solution and would not meet the requirements.
upvoted 7 times
...
...
PaulGa
Most Recent 2 months ago
Selected Answer: C
Ans C. Its the only one that offers right level of scaling and availability
upvoted 1 times
...
OBIOHAnze
4 months, 3 weeks ago
Selected Answer: C
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.
upvoted 3 times
...
A_jaa
9 months ago
Selected Answer: C
Answer-c
upvoted 1 times
...
Ndlesty
11 months ago
Selected Answer: C
key statement: "...will automatically scale the database to meet the demand of unpredictable read workloads while maintaining high availability.
upvoted 1 times
...
AWSGuru123
1 year ago
Selected Answer: C
Aurora
upvoted 1 times
...
Syruis
1 year, 2 months ago
Selected Answer: C
C fit perfectly
upvoted 1 times
...
TariqKipkemei
1 year, 2 months ago
Selected Answer: C
Unpredictable read workloads while maintaining high availability = Amazon Aurora with a Multi-AZ deployment, Auto Scaling with Aurora read replicas.
upvoted 1 times
...
Guru4Cloud
1 year, 2 months ago
Selected Answer: C
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.
upvoted 1 times
...
miki111
1 year, 3 months ago
Option C MET THE REQUIREMENT
upvoted 1 times
...
hiepdz98
1 year, 3 months ago
Selected Answer: C
Option C
upvoted 1 times
...
cookieMr
1 year, 4 months ago
Selected Answer: 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.
upvoted 2 times
...
Bmarodi
1 year, 4 months ago
Selected Answer: C
C meets the requirements.
upvoted 1 times
...
Mehkay
1 year, 4 months ago
C Aurora with read replicas
upvoted 1 times
...
big0007
1 year, 5 months ago
Key words: - Must support MySQL - High Availability (must be mulit-az) - Auto Scaling
upvoted 4 times
...
cheese929
1 year, 5 months ago
Selected Answer: C
C is correct since cost is not a concern.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...