A city must migrate an on-premises Oracle database to Aurora PostgreSQL and keep data replicating until cutover. Which AWS service is designed for that database migration and replication work?
Select an answer to reveal the explanation.
Short Explanation
DMS is the moving van that can keep carrying boxes while you finish packing—the service migrates databases and can keep replicating changes until you flip the switch. CloudFront caches web content, Shield is DDoS protection, and Cognito handles user sign-in—not database moves.
Full Explanation
A city that must migrate an on-premises Oracle database to Aurora PostgreSQL and keep data replicating until cutover should use AWS Database Migration Service (AWS DMS). DMS migrates and replicates databases—including heterogeneous engine paths—with ongoing change data capture so applications can keep running until a controlled cutover. For municipal Oracle-to-Aurora PostgreSQL projects, DMS is the service purpose-built for that migration and continuous replication work.
Amazon CloudFront is a content delivery network, not a database replication engine. AWS Shield provides DDoS protection and is not a schema or data migration tool. Amazon Cognito manages application authentication and user pools; it is not a continuous database sync service between Oracle and Aurora.
Exam caveat: Migration with ongoing replication → DMS. Heterogeneous engine changes often also use AWS Schema Conversion Tool (SCT) for schema objects. Do not assign CDN, Shield, or Cognito to database migration roles on the exam.
Operational check: assess the Oracle source, convert schema with SCT where required, configure DMS replication instance and tasks into Aurora PostgreSQL, validate row counts and critical finance or permitting queries, rehearse cutover on a weekend, and retire old connections only after backups and application smoke tests succeed.