CloudGuild · Blog · Cheat sheets · Lessons · Certifications
Understanding AWS Database Services: A Walkthrough of the DEA-C01 Exam Question
Explore a key DEA-C01 question regarding AWS database services. Learn about correct answers and common pitfalls.
A common hurdle for candidates is distinguishing between AWS database services. Each service has unique features, making the choice seem daunting. Let's clarify this with a specific question from the DEA-C01 exam.
The question
A company is planning to migrate its on-premises relational database to AWS. They want a fully managed service that can automatically scale, handle transactions, and provide high availability. Which AWS service should they choose?
- A. Amazon DynamoDB
- B. Amazon RDS
- C. Amazon Redshift
- D. Amazon Aurora
Think before you scroll
Before making your choice, consider the requirements: fully managed, automatic scaling, transaction handling, and high availability. Each option serves different purposes, impacting their suitability for relational databases.
The answer
The correct option is B. Amazon RDS. This service is explicitly designed for relational databases. It offers automatic scaling, transaction support, and high availability features. It's a direct fit for the need to manage a relational database in AWS.
Why the other options lose
- A. Amazon DynamoDB: This is a NoSQL database. It excels in handling unstructured data and offers high scalability. However, it lacks built-in support for traditional relational database transactions, making it unsuitable for this scenario.
- C. Amazon Redshift: This service is primarily a data warehousing solution. It is optimized for analytical queries rather than transactional workloads, which disqualifies it as a direct answer for relational database management.
- D. Amazon Aurora: While Aurora is indeed a strong contender as a fully managed relational database, it is a specific implementation under the broader Amazon RDS umbrella. The question seeks a service that encompasses all relational database needs, making RDS the more comprehensive choice.
The concept behind it
Understanding the purpose of each AWS database service is crucial. Amazon RDS supports multiple relational database engines, including MySQL and PostgreSQL, providing flexibility and ease of management. This understanding allows you to apply this knowledge to similar questions.
Exam trap to remember
Remember: RDS is the go-to for managed relational databases. If the question emphasizes relational databases with transaction support, RDS should be your answer.