CloudGuild · Blog · Cheat sheets · Lessons · Certifications
Exam Question Walkthrough for AWS Certified Solutions Architect - Associate (SAA-C03)
Understand why AWS candidates struggle with SQL database solutions. Explore a specific exam question and improve your chances of passing the SAA-C03.
A common decision point for candidates involves choosing the right SQL database solution. Many overlook key features like automatic failover and quick recovery. This question tests your understanding of these critical requirements.
The question
A company is deploying a new application that requires a highly available SQL database solution with automatic failover and quick recovery. Which AWS service would best meet these requirements?
- A) Amazon Aurora with Multi-AZ deployments
- B) Amazon RDS for PostgreSQL with Read Replicas
- C) Amazon DynamoDB with Global Tables
- D) Amazon Redshift with Snapshots
Think before you scroll
Before you choose an option, consider what high availability and automatic failover mean in the context of SQL databases. These features are essential for minimizing downtime and ensuring data integrity during failures. Reflect on which AWS services specifically address these needs.
The answer
The correct option is A) Amazon Aurora with Multi-AZ deployments. This service provides high availability with built-in automatic failover. It is designed specifically for quick recovery, making it the best choice for the requirements stated.
Why the other options lose
- B) Amazon RDS for PostgreSQL with Read Replicas: While RDS can improve read scalability with Read Replicas, it does not provide automatic failover. This option does not meet the application’s availability requirements.
- C) Amazon DynamoDB with Global Tables: DynamoDB is a NoSQL database. It is not designed for SQL workloads and does not provide the features needed for high availability in a SQL context.
- D) Amazon Redshift with Snapshots: Redshift is optimized for analytics and not for transactional workloads. Snapshots are useful for backups but do not offer automatic failover or quick recovery in the way required.
The concept behind it
High availability in database services requires features like automatic failover and quick recovery. In AWS, services like Amazon Aurora are designed specifically for these scenarios. Understanding the strengths and weaknesses of each service helps in selecting the right solution for specific application needs.
Exam trap to remember
When faced with high availability questions, remember: Look for automatic failover and recovery features. They are key indicators of a suitable solution.