ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to 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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
milofficial
Highly Voted 1 year, 3 months ago
Selected Answer: B
Whoever is the admin that pre-marks the answers, it's time to go
upvoted 21 times
...
TonyStark0122
Highly Voted 1 year, 3 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 8 months, 1 week ago
Hahaha, I loved the "downtown" typo in the question. I always say the same instead of "downtime"..
upvoted 1 times
...
San_Juan
8 months, 3 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
8 months, 1 week ago
Right, but Snowball isn't mentioned in Option D. Thus, you can't consider it as OK.
upvoted 3 times
...
...
pypelyncar
11 months, 1 week 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 ago
AWS Database Migration Service (DMS)
upvoted 1 times
...
lucas_rfsb
1 year, 1 month ago
Selected Answer: B
B Since it's for Migration porpouse, typical for DMS
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago