A nightly job must move data from an on-premises database to S3. Which service fits?
Why D is the answer
AWS Database Migration Service
DMS migrates and replicates data from databases.
In detail
- DMS moves data from databases.
- It also supports ongoing replication.
Use case
An illustrative scenario, not a real incident.
An on-premises orders database replicates to S3 with DMS, each night, for analytics.
See it in different ways
mindmap
root((Ingestion))
Streams
Kinesis Data Streams
Amazon MSK
Delivery
Data Firehose
Databases
AWS DMS
Files
S3 eventsflowchart LR S0["On-premises database"] --> S1["AWS DMS"] --> S2["Amazon S3"]
Key point: DMS moves data from databases.
Why the other options are wrong
- A. AWS Snowball Edge, shipped each night
- Shipping a device each night is impractical.
- B. Amazon Data Firehose
- Firehose delivers streams, and does not read a database.
- C. AWS Backup
- Backup protects resources.

