Bitzu

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

Single choice

Which AWS service migrates data from an on-premises database into Amazon RDS while the source database stays operational?

  1. AWS Backup
  2. AWS Storage Gateway
  3. AWS Database Migration Service
  4. 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.

Select all that apply

Which components must exist before you can create an AWS DMS migration task?

  1. A replication instance
  2. A source endpoint
  3. An Amazon ElastiCache cluster
  4. A target endpoint
  5. 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.

True or false

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.

Download on the App StoreGet it on Google Play

More CLF-C02 topics in this module