AWS Certified Data Engineer – Associate (DEA-C01) — Question 10

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 downtown for the applications that access the database.
Which AWS service should the company use to meet these requirements?

Answer options

Correct answer: B

Explanation

AWS Database Migration Service (AWS DMS) is specifically designed to facilitate the migration of databases to AWS while minimizing downtime, making it the best choice for this scenario. AWS Lambda is a serverless compute service that does not directly aid in database migration. AWS Direct Connect provides a dedicated network connection but does not address the migration process itself. AWS DataSync is used for transferring data to and from AWS storage services, not specifically for databases.