AWS Certified Solutions Architect – ProfessionalAccelerate Workload Migration and ModernizationEasy
A company is migrating a complex, multi-tier enterprise application from on-premises to AWS. The application uses Microsoft SQL Server as its database backend and requires high performance and availability. The company wants to leverage AWS managed services to reduce the operational burden of database administration, while also ensuring compatibility with their existing SQL Server tools and expertise. Which AWS database service should be chosen?
- AAmazon Redshift
- BAmazon RDS for SQL Server
- CAmazon Aurora PostgreSQL-Compatible Edition
- DAmazon DynamoDB
Show answer & explanationAnswer & explanation
Correct answer: B. Amazon RDS for SQL Server
Amazon RDS for SQL Server is a fully managed relational database service that supports Microsoft SQL Server. It provides high availability, scalability, automated backups, and patching, significantly reducing operational burden while maintaining compatibility with existing SQL Server applications and tools.
Why the other options are wrong
- A. Amazon Redshift is a data warehousing service, optimized for analytical workloads, not a transactional database for an enterprise application backend.
- C. Amazon Aurora PostgreSQL-Compatible Edition is a relational database but is not compatible with Microsoft SQL Server, requiring a heterogeneous migration and application re-platforming.
- D. Amazon DynamoDB is a NoSQL database, not suitable for a relational SQL Server application without a complete re-architecture.
Amazon Relational Database Service (RDS)
A managed service that makes it easy to set up, operate, and scale a relational database in the cloud. It supports several popular database engines.
- Supports MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and Amazon Aurora.
- Automates administrative tasks like patching, backups, and replication.
- Provides high availability, scalability, and security features.
Memory trick: RDS for Relational, DynamoDB for NoSQL, Redshift for Warehouse.