Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 136 discussion

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. ... With AWS Database Migration Service, you can also continuously replicate data with low latency from any supported source to any supported target. https://aws.amazon.com/dms/

AC, here it is clearly shown https://docs.aws.amazon.com/zh_cn/dms/latest/sbs/chap-manageddatabases.postgresql-rds-postgresql.html

Ans C, E - C: AWS Database Migration Service to migrate databases to AWS, source database remains fully operational during the migration, avoiding application downtime. https://aws.amazon.com/dms/ E: monitor with CloudWatch As for C - not convinced: its PostgreSQL to PostgreSQL migration... no SCT is needed?

A and c obviously

AC is more accurate as DMS will help to migrate the on-premises data base to cloud with ease and for ongoing replication to synchronized the datbase "ongiong replication task" will be helpfull. And yes its PostgreSQL to PostgreSQL migration so no SCT is needed ehre

WeLL CHATGPT says SCT is not required so , AC makes sense

Keywords: - migrating its on-premises PostgreSQL database to Amazon Aurora PostgreSQL - The Aurora database must remain synchronized with the on-premises database Analysis: Option A satisfy the requirement of “synchronized with the on-premises database” Option C suits for the homogeneous database migration. Option D is not needed in this scenario, it suits for the heterogeneous database. Homogeneous database migration tools: https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-oracle-database/homogeneous-migration-tools.html Heterogeneous database migration tools: https://aws.amazon.com/dms/schema-conversion-tool/

CD: Migrating a schema from PostgreSQL to Amazon Aurora (PostgreSQL) usually requires using the AWS Schema Conversion Tool (SCT) and the AWS Database Migration Service (DMS)

To meet the requirements of migrating an on-premises PostgreSQL database to Amazon Aurora PostgreSQL while keeping the on-premises database online and ensuring synchronization with the Aurora database, the following actions need to be taken: Create an ongoing replication task (Option A): This action involves setting up continuous replication between the on-premises PostgreSQL database and the Aurora PostgreSQL database. This ensures that changes made to the on-premises database are replicated to the Aurora database in real-time, keeping them synchronized. Create an AWS Database Migration Service (AWS DMS) replication server (Option C): AWS DMS provides a reliable and efficient way to migrate databases to AWS while minimizing downtime. By creating an AWS DMS replication server, you can configure and manage the replication tasks between the on-premises database and the Aurora database.

answer is CD : postgresql and aurora postgresql have different schemes, you need sct for conversion and dms for the migration (replication)

AC perform ongoing replication using AWS DMS to keep the source and target databases in sync

DMS has Continuous Data Replication using CDC

CD A is out because it does not specify what is the service to perform the replication task, clearly what needed here is DMS B is out because backup is solution to keep 2 DB in sync, backup and restore takes long time C is correct as DMS takes care both full load and ongoing replication, see this youtube video https://www.youtube.com/watch?v=VhXDa9SPDLw D is right as from to PostgreSQL to Amazon Aurora PostgreSQL you need AWS Schema Conversion Tool, see https://aws.amazon.com/dms/schema-conversion-tool/ E is out monitor itself doen't perform the replication work, if we have to choose 3 options then we can have E selected

Well technically when you operate such task, you must create a database on the cloud, then operate a migration using DMS and none of the propositions give you those two tasks separately. Sometimes those questions can be really frustrating.

C. Create an AWS Database Migration Service (AWS DMS) replication server. E. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization. AWS DMS can replicate data from on-premises databases to Aurora PostgreSQL in real time, so the on-premises database will remain online and accessible during the migration. AWS DMS can also automatically convert the database schema, so there is no need to use AWS SCT. An Amazon EventBridge rule can be used to monitor the database synchronization and send notifications if any errors occur. This is important because it allows the solutions architect to quickly identify and resolve any issues that may arise during the migration. A database backup of the on-premises database is not necessary because AWS DMS will replicate the data in real time. Creating an ongoing replication task is not necessary because AWS DMS will automatically create an ongoing replication task when the replication server is created.

Create an AWS Database Migration Service (AWS DMS) replication server then create an ongoing replication task

A) Create an ongoing replication task C) Create an AWS Database Migration Service (AWS DMS) replication server The key reasons are: An ongoing DMS replication task keeps the source and target databases synchronized during the migration. The DMS replication server manages and executes the replication tasks. Together, these will continuously replicate changes from on-prem to Aurora to keep them in sync. A database backup alone wouldn't maintain synchronization.