AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company is migrating its on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The on-premises database must remain online and accessible during the migration. The Aurora database must remain synchronized with the on-premises database.
Which combination of actions must a solutions architect take to meet these requirements? (Choose two.)
Other
Community
UAnonymous
A
Create an ongoing replication task.
B
Create a database backup of the on-premises database.
C
Create an AWS Database Migration Service (AWS DMS) replication server.
D
Convert the database schema by using the AWS Schema Conversion Tool (AWS SCT).
E
Create an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization.
Explanation:
Explanation
To meet the requirements of migrating an on-premises PostgreSQL database to Amazon Aurora PostgreSQL while keeping the on-premises database online and maintaining synchronization, the correct approach is:
A. Create an ongoing replication task. - This is essential for continuous data replication from the on-premises PostgreSQL database to Aurora PostgreSQL. AWS DMS uses replication tasks to keep the target database synchronized with the source.
C. Create an AWS Database Migration Service (AWS DMS) replication server. - AWS DMS requires a replication instance (server) to perform the migration and ongoing replication tasks. This server runs the replication engine and manages connections between source and target databases.
Why the other options are incorrect:
B. Create a database backup of the on-premises database. - While backups are good practice, they don't enable ongoing synchronization. A one-time backup would create a static copy, not maintain continuous synchronization.
D. Convert the database schema by using the AWS Schema Conversion Tool (AWS SCT). - AWS SCT is used for heterogeneous database migrations (e.g., Oracle to PostgreSQL), but since both source and target are PostgreSQL databases, schema conversion is not needed. The schemas are already compatible.
E. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization. - While monitoring is important, it's not a requirement for the migration and synchronization itself. AWS DMS provides its own monitoring capabilities through CloudWatch metrics.
Key AWS DMS Components for This Scenario:
- Replication Instance: The server that runs the replication engine
- Source Endpoint: Connection to on-premises PostgreSQL
- Target Endpoint: Connection to Aurora PostgreSQL
- Replication Task: Defines what data to migrate and how to keep it synchronized
This approach enables a zero-downtime migration with continuous data replication, allowing the on-premises database to remain operational throughout the process.
Comments
Loading comments...