Q50 — AWS SAA-C03 第3章

第 50/65 题 | ← 返回第3章

Q180.一家公司正在将其本地 PostgreSQL 数据库迁移到 Amazon Aurora PostgreSQL.在迁移过程中，本地数据库必须保持在线且可访问. Aurora 数据库必须与本地数据库保持同步.解决方案架构师必须采取哪些行动组合才能满足这些要求? （选择两个.）

正确答案: A. 创建一个正在进行的复制任务., C. 创建一个 AWS Database Migration Service (AWS DMS) 复制服务器.

解析

To meet the requirements of migrating an on-premises PostgreSQL database to Amazon Aurora PostgreSQL while keeping both databases online and accessible, a solutions architect should take the following two actions:A. Create an ongoing replication task using AWS Database Migration Service (AWS DMS) to replicate data from the on-premises PostgreSQL database to Aurora PostgreSQL. This allows for real-time synchronization between the two databases.C. Create an AWS Database Migration Service (AWS DMS) replication server to manage the ongoing replication task. The replication server will handle the migration of data from the on-premises PostgreSQL database to Aurora PostgreSQL, ensuring that the two databases remain in sync throughout the migration process.Creating a backup of the on-premises database (option B) and converting the database schema using AWS Schema Conversion Tool (AWS SCT) (option D) are not necessary steps to complete this migration. Lastly, creating an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization (option E) is an optional step to ensure that the synchronization is working as expected, but it is not required to meet the requirements stated in the question.为了满足将本地PostgreSQL数据库迁移到Amazon Aurora PostgreSQL的需求，同时保持两个数据库的在线和可访问性，解决方案架构师应该采取以下两个行动:A.使用AWS数据库迁移服务(AWS DMS)创建一个正在进行的复制任务，将本地PostgreSQL数据库的数据复制到Aurora PostgreSQL。这允许两个数据库之间的实时同步。C.创建AWS DMS (Database Migration Service)复制服务器，管理正在进行的复制任务。复制服务器将处理从本地PostgreSQL数据库到Aurora PostgreSQL的数据迁移，确保两个数据库在整个迁移过程中保持同步。创建本地数据库的备份(选项B)和使用AWS模式转换工具(AWS SCT)转换数据库模式(选项D)不是完成此迁移的必要步骤。最后，创建一个Amazon EventBridge (Amazon CloudWatch Events)规则来监视数据库同步(选项E)是一个可选的步骤，可以确保同步按预期工作，但这不是满足问题中所述需求所必需的。