AWS Certified Solutions Architect – ProfessionalAccelerate Workload Migration and ModernizationMedium
A healthcare provider is modernizing its patient appointment scheduling system. The existing on-premises system uses a Microsoft SQL Server database which is heavily reliant on stored procedures, triggers, and proprietary SQL Server features for business logic. The company wants to migrate this database to AWS to improve scalability and reduce administrative overhead, while minimizing application code changes. Which AWS service is the MOST appropriate target for the migrated database?
- AAmazon RDS for SQL Server
- BAmazon DynamoDB
- CAmazon Aurora PostgreSQL-Compatible Edition
- DAmazon Aurora MySQL-Compatible Edition
Show answer & explanationAnswer & explanation
Correct answer: A. Amazon RDS for SQL Server
Amazon RDS for SQL Server provides a fully managed SQL Server database in AWS, supporting native SQL Server features, stored procedures, and triggers. This minimizes application code changes during migration and reduces administrative overhead.
Why the other options are wrong
- B. Amazon DynamoDB is a NoSQL database and would require a complete re-architecture of the application's data model and logic, which is not suitable for minimizing code changes from a relational SQL Server database.
- C. Aurora PostgreSQL-Compatible Edition is a relational database but requires extensive refactoring of SQL Server-specific stored procedures, triggers, and queries, which violates the requirement to minimize application code changes.
- D. Aurora MySQL-Compatible Edition is a relational database but, like PostgreSQL, would necessitate significant refactoring of SQL Server-specific code and features, contradicting the goal of minimizing code changes.
Amazon RDS for SQL Server
A fully managed service that makes it easy to set up, operate, and scale Microsoft SQL Server deployments in the cloud.
- Supports native SQL Server features (stored procedures, triggers).
- Automates backups, patching, and high availability.
- Minimizes code changes for SQL Server migrations.
- Offers various SQL Server editions and versions.
Memory trick: RDS SQL Server, Same SQL, Simple Shift