DEA-C01 question 16: A company uses an on-premises Microsoft SQL Server database to stor…

Q17Data Ingestion and Transformation

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?

← → navigate · a answer

Community votes

100% (5)

0% (0)

Discussion · 9

B 22

Selected Answer: B Whoever the admin is that pre-marks the answers, it's time to go

B. AWS Database Migration Service (AWS DMS) Explanation: AWS Database Migration Service (DMS) is purpose-built for migrating data from many sources, including on-premises databases, to AWS with minimal downtime and little disruption to applications. It supports homogeneous migrations (e.g., SQL Server to SQL Server) as well as heterogeneous migrations (e.g., SQL Server to Amazon RDS for SQL Server).

Right, but Snowball is not mentioned in Option D. So, you can't treat it as OK.

B 2

Selected Answer: B B Since it's for migration purpose, typical for DMS

B 2

Selected Answer: B AWS DMS provides a cost-effective option for database migrations compared to replicating data to a fully managed RDS instance. You only pay for the resources used during the migration, which makes it ideal for infrequent, monthly transfers

D could be OK. I mean, it is about migrating to a cloud database and turning off the current on-premise database. So you could use AWS Snowball Edge Storage to move the backup of the on-premises database, and once it is in the edge storage, copy the data to a new cloud-based SQL server instance using AWS DataSync https://aws.amazon.com/es/blogs/storage/seamlessly-migrate-large-sql-databases-using-aws-snowball-and-aws-datasync/

AWS Database Migration Service (DMS)

Hahaha, I liked the "downtown" typo in the question. I always say the same instead of "downtime"..

B 1

Selected Answer: B DMS uses CDC (change data capture), which helps minimize the amount of data that needs to be transferred.