Question
A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.
The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtime for the applications that access the database.
Which AWS service should the company use to meet these requirements?
- A. AWS Lambda
- B. AWS Database Migration Service (AWS DMS) Correct
- C. AWS Direct Connect
- D. AWS DataSync
Explanation
AWS Database Migration Service (AWS DMS) is designed to migrate databases with minimal downtime and can support ongoing replication, which would reduce the cost associated with periodic large data migrations. It supports Microsoft SQL Server as a source and Amazon RDS for SQL Server as a target, making it suitable for the company's needs without causing significant downtime.
