Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 16 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 16
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

A. AWS Lambda
B. AWS Database Migration Service (AWS DMS)
C. AWS Direct Connect
D. AWS DataSync

Show Suggested Answer

Suggested Answer: B 🗳️

by milofficial at Jan. 20, 2024, 11:54 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

milofficial

Highly Voted 1 year, 5 months ago

Selected Answer: B

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

upvoted 22 times

...

TonyStark0122

Highly Voted 1 year, 5 months ago

B. AWS Database Migration Service (AWS DMS) Explanation: AWS Database Migration Service (DMS) is specifically designed for migrating data from various sources, including on-premises databases, to AWS with minimal downtime and 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).

upvoted 13 times

...

shammous

Most Recent 9 months, 4 weeks ago

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

upvoted 1 times

...

San_Juan

10 months, 2 weeks ago

D could be OK. I mean, it is talking about migrating to a cloud database and switching-off the current on-premise database. So you could use AWS Snowball Edge Storage to move the backup of the on-premises database, and when 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/

upvoted 2 times

shammous

9 months, 4 weeks ago

Right, but Snowball isn't mentioned in Option D. Thus, you can't consider it as OK.

upvoted 3 times

...

pypelyncar

1 year ago

Selected Answer: B

AWS DMS offers a cost-effective solution for database migrations compared to replicating data to a fully managed RDS instance. You only pay for the resources used during the migration, making it ideal for infrequent, monthly transfers

upvoted 2 times

...

xaocho

1 year, 2 months ago

AWS Database Migration Service (DMS)

upvoted 1 times

...

lucas_rfsb

1 year, 3 months ago

Selected Answer: B

B Since it's for Migration porpouse, typical for DMS

upvoted 2 times

...