AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company manages its own Amazon EC2 instances that run MySQL databases. The company is manually managing replication and scaling as demand increases or decreases. The company needs a new solution that simplifies the process of adding or removing compute capacity to or from its database tier as needed. The solution also must offer improved performance, scaling, and durability with minimal effort from operations.
Which solution meets these requirements?
Other
Community
UAnonymous
A
Migrate the databases to Amazon Aurora Serverless for Aurora MySQL.
B
Migrate the databases to Amazon Aurora Serverless for Aurora PostgreSQL.
C
Combine the databases into one larger MySQL database. Run the larger database on larger EC2 instances.
D
Create an EC2 Auto Scaling group for the database tier. Migrate the existing databases to the new environment.
Explanation:
Explanation
Correct Answer: A - Migrate the databases to Amazon Aurora Serverless for Aurora MySQL
Why Option A is Correct:
- Automatic Scaling: Amazon Aurora Serverless automatically scales compute capacity up and down based on actual usage, eliminating manual scaling efforts.
- MySQL Compatibility: Since the company currently uses MySQL databases, migrating to Aurora Serverless for Aurora MySQL maintains compatibility while gaining serverless benefits.
- Minimal Operational Effort: Aurora Serverless handles provisioning, patching, backup, recovery, and scaling automatically.
- Improved Performance & Durability: Aurora provides up to 5x better performance than standard MySQL and replicates data across 3 Availability Zones with 6 copies for high durability.
- Cost Optimization: You only pay for the database capacity you use when it's active.
Why Other Options Are Incorrect:
Option B: While Aurora Serverless for PostgreSQL offers similar benefits, the company uses MySQL databases. Migrating to PostgreSQL would require application changes and database migration efforts, which contradicts the requirement for minimal effort.
Option C: Combining databases into one larger instance on EC2 still requires manual management of scaling, replication, and durability. It doesn't simplify the process or provide automatic scaling.
Option D: EC2 Auto Scaling groups can scale compute instances, but they don't automatically handle database replication, failover, or data durability. Database scaling on EC2 still requires manual intervention for replication setup, backup, and recovery.
Key Benefits of Aurora Serverless:
- Automatic Scaling: Scales compute capacity in seconds based on application demand
- High Availability: Built-in multi-AZ replication with automatic failover
- Durability: Data is replicated across 3 AZs with 6 copies
- MySQL Compatibility: Fully compatible with existing MySQL applications
- Serverless Operations: No need to manage database instances, capacity planning, or scaling operations
Comments
Loading comments...