CloudGuild · Blog · Cheat sheets · Lessons · Certifications
AWS Certified Solutions Architect - Associate Exam Question Walkthrough
Explore a key AWS exam question on database solutions and learn how to identify the correct answer with our detailed analysis.
A common pitfall for candidates is understanding the nuances between AWS database services. The options may seem similar at first glance, but the decision hinges on automatic scaling and cost-effectiveness.
The question
A business requires a database solution that automatically scales and handles variable workloads while remaining cost-effective. Which combination of services would best meet these requirements?
- A) Amazon Aurora with Auto Scaling
- B) Amazon RDS for MySQL
- C) Amazon DynamoDB
- D) Amazon ElastiCache
Think before you scroll
Before choosing an answer, consider the requirements: automatic scaling, handling variable workloads, and cost-effectiveness. Each option has distinct features that cater to different needs.
The answer
The correct option is C) Amazon DynamoDB. This service is a fully managed NoSQL database that scales automatically and adjusts to variable workloads, making it a cost-effective choice for businesses.
Why the other options lose
- A) Amazon Aurora with Auto Scaling: While Aurora offers scaling capabilities, it generally incurs higher costs compared to DynamoDB. It does not automatically scale for variable workloads as effectively as DynamoDB.
- B) Amazon RDS for MySQL: RDS can handle variable workloads but lacks the automatic scaling feature that DynamoDB provides. This limitation makes it less suitable for businesses that require dynamic scaling.
- D) Amazon ElastiCache: ElastiCache is designed for caching and does not serve as a primary database solution. It does not meet the requirement for variable workloads either.
The concept behind it
The principle at work here is understanding the differences between database types: relational versus NoSQL. NoSQL databases like DynamoDB are built for scalability and flexibility, especially under varying workloads, making them ideal for applications with unpredictable traffic.
Exam trap to remember
Remember: when asked about automatic scaling in databases, if NoSQL is an option, it’s often the right choice for variable workloads.