CLF-C02 ยท Database services
AWS DMS and AWS SCT
AWS Database Migration Service for homogeneous and heterogeneous migrations and ongoing replication, and AWS Schema Conversion Tool for converting schemas between engines.
Key points
- AWS DMS: moves data between databases, homogeneous (same engine) or heterogeneous (e.g. Oracle to Aurora PostgreSQL).
- Pieces: replication instance, source endpoint, target endpoint, task.
- Types: full load, full load plus change data capture (CDC), or changes only; the source keeps running.
- Heterogeneous: first convert schemas and code with AWS SCT or DMS Schema Conversion; unconvertible items get manual guidance.
Source: https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
Practice questions
Which AWS service migrates data from an on-premises database into Amazon RDS while the source database stays operational?
- AWS Backup
- AWS Storage Gateway
- AWS Database Migration Service
- Amazon ElastiCache
Show answer
Answer: C. AWS Database Migration Service
AWS DMS copies existing data and can replicate ongoing changes, so the source keeps serving the application. AWS Backup protects data, Storage Gateway connects on-premises storage to the cloud, and ElastiCache is a cache, not a migration tool.
Which components must exist before you can create an AWS DMS migration task?
- A replication instance
- A source endpoint
- An Amazon ElastiCache cluster
- A target endpoint
- An Amazon Redshift cluster
Show answer
Answer: A. A replication instance, B. A source endpoint, D. A target endpoint
A DMS task runs on a replication instance and moves data from a source endpoint to a target endpoint, so all three are created first. An ElastiCache cluster and a Redshift cluster are not prerequisites.
AWS DMS can only migrate between identical database engines, such as MySQL to MySQL.
Show answer
Answer: False
False. DMS supports homogeneous migrations and fully heterogeneous migrations between supported engines, for example to Aurora, Redshift, DynamoDB or S3.
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
