AWS Service for Cost-Effective SQL Server Migration

DEA-C01 By islever Editorial Last updated

Orchestrate data pipelines. Choose a data store.

Short answer

B Use AWS Database Migration Service (AWS DMS) to migrate the financial transaction data to Amazon RDS with minimal downtime.

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 downtown for the applications that access the database. Which AWS service should the company use to meet these requirements?
  1. AWS Lambda
  2. AWS Database Migration Service (AWS DMS) Correct Answer
  3. AWS Direct Connect
  4. AWS DataSync

Key Takeaways

The core concept is choosing a managed migration service over generic transfer tools when database-specific replication and schema handling are required.

This question evaluates the selection of AWS Database Migration Service (DMS) for migrating on-premises Microsoft SQL Server data to Amazon RDS with minimal downtime.

Common mistake: Candidates often select AWS DataSync, assuming it handles all data movement; however, DataSync lacks the database-level transactional consistency and CDC capabilities needed for live or near-live DB migrations.

Expert Analysis

Why the Answer Is Correct

AWS Database Migration Service (DMS) is purpose-built for moving data between heterogeneous or homogeneous databases with minimal downtime. It supports continuous data replication using Change Data Capture (CDC), which allows the source database to remain available during the migration process, directly addressing the "minimal downtime" requirement. For monthly migrations, DMS can be configured as a one-time load or continuous sync, making it cost-effective compared to maintaining complex custom scripts.

Why the Other Options Are Wrong

AWS Lambda (A) requires custom code to handle database connections and transformation logic, increasing development overhead and risk. AWS Direct Connect (C) provides network connectivity but does not migrate data itself; it merely connects the on-premises environment to AWS VPC. AWS DataSync (D) is designed for file-based transfers (SMB/NFS) and object storage, lacking the ability to understand database schemas, transactions, or perform online schema changes required for SQL Server.

Community Comment Notes

The community overwhelmingly supports Option B, recognizing DMS as the standard tool for database migrations. One user noted the typo "downtown" instead of "downtime," highlighting the importance of reading closely. Another user pointed out that while Snowball/DataSync might work for bulk backups, they do not offer the seamless, low-downtime experience DMS provides for active database access.

Official Reference

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html

This link opens the official vendor documentation in a new tab.

Exam Strategy

Always look for keywords like 'database', 'migration', and 'minimal downtime'. If the scenario involves moving structured data between databases, DMS is almost always the correct choice over general-purpose networking or storage services.

Frequently Asked Questions

Why not use AWS DataSync for database migration?

DataSync moves files and objects, not database transactions. It cannot maintain referential integrity or provide the continuous replication needed for minimal downtime.

Is DMS expensive for monthly migrations?

No, DMS is pay-as-you-go. You only pay for the replication instance duration, making it cost-effective for infrequent or scheduled migrations compared to building custom ETL pipelines.

More DEA-C01 FAQ →

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 7 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 7

  1. milofficial 👍 21 Answered B
    Whoever is the admin that pre-marks the answers, it's time to go
  2. TonyStark0122 👍 13
    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).
  3. San_Juan 👍 2
    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/
  4. pypelyncar 👍 2 Answered 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
  5. lucas_rfsb 👍 2 Answered B
    B Since it's for Migration porpouse, typical for DMS
Show 2 more comments
  1. shammous 👍 1
    Hahaha, I loved the "downtown" typo in the question. I always say the same instead of "downtime"..
  2. xaocho 👍 1
    AWS Database Migration Service (DMS)

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Amazon Redshift Compound Sort Key Query Optimization

S-grade

Secure Redshift Spectrum Access with VPC Endpoints

S-grade

Athena Federated Query for Multi-Source Iceberg Pipelines

S-grade

Reclaiming Storage in Amazon Redshift Materialized Views

S-grade

Practice All DEA-C01 Questions

Access 100 questions with complete answers and detailed explanations.

View Full DEA-C01 Practice Test →

← Back to DEA-C01 Study Guide