A company migrates monthly from an on-premises Microsoft SQL Server to Amazon RDS for SQL Server. Migration costs have risen and the company wants a cost-effective approach with minimal application downtime. Which AWS service should they use?
Choose an answer
Tap an option to check your answer.
Correct answer: AWS Database Migration Service (AWS DMS).
Why this is the answer
AWS Database Migration Service (AWS DMS) is the most suitable choice because it allows for continuous data replication from on-premises SQL Server to Amazon RDS for SQL Server with minimal downtime. This addresses the need for a cost-effective migration and reduces application impact. AWS DMS can perform a full load of the data and then continuously replicate changes, keeping the target database synchronized with the source. AWS Lambda is a serverless compute service and is not designed for database migration. AWS Direct Connect provides a dedicated network connection but doesn't handle the data migration itself. AWS DataSync is used for transferring large amounts of data between on-premises storage and AWS storage services, not specifically for database migrations with continuous replication.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed