Examkin

Soru

Zorluk: KolayDatabase Migration and Schema Conversion using DMS and SCT

An organization is planning to migrate a self-managed Oracle database running on Amazon EC2 to an Amazon RDS for PostgreSQL DB instance. The migration must involve converting the database schema (including stored procedures) and replicating data with minimal downtime.

Which of the following actions should the organization perform to accomplish this database migration? (Select TWO.)

  1. Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle database schema and stored procedures into PostgreSQL-compatible definitions.Cevap
  2. Use AWS Database Migration Service (AWS DMS) to migrate the data from the source Oracle database to the target Amazon RDS for PostgreSQL DB instance.Cevap
  3. C
    Use AWS Application Migration Service (AWS MGN) to perform a block-level server migration, which will automatically convert the database engine and code.
  4. D
    Configure an AWS DMS replication task for ongoing Change Data Capture (CDC) without enabling supplemental logging on the source Oracle database.
  5. E
    Configure an Amazon RDS for PostgreSQL read replica directly from the source Oracle database on EC2 to handle the real-time data replication.

Cevap

Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle database schema and stored procedures, and use AWS Database Migration Service (AWS DMS) to migrate the data.
For a heterogeneous database migration (Oracle to PostgreSQL), two primary steps are required: converting the schema and migrating the data. The AWS Schema Conversion Tool (AWS SCT) converts the database schema, including stored procedures, views, and other database objects. AWS Database Migration Service (AWS DMS) is then used to perform the data migration, supporting both full load and replication (Change Data Capture) to minimize downtime.

Adım Adım Çözüm

1
Analyze the database schema conversion requirements.
Identify that migrating from Oracle (source) to PostgreSQL (target) is a heterogeneous migration requiring schema translation before data can be loaded.
Heterogeneous database migrations cannot use native replication directly without schema conversion first.
2
Select the appropriate tool for schema and code conversion.
Select AWS Schema Conversion Tool (AWS SCT) to convert database schemas, stored procedures, views, and functions to PostgreSQL-compatible versions.
AWS SCT is the primary AWS tool designed specifically for converting database schemas and application code between different database engines.
3
Select the appropriate service for data replication and migration.
Select AWS Database Migration Service (AWS DMS) to perform the initial full load and subsequent Change Data Capture (CDC) to keep the target database in sync with the source.
AWS DMS is designed to migrate data from a source database to a target database, supporting heterogeneous engine replication.

Anahtar Kavram

Heterogeneous database migration using AWS Schema Conversion Tool (AWS SCT) for schema conversion and AWS Database Migration Service (AWS DMS) for data migration.
Bu soruyu puanla

Konular

Database Migration and Schema Conversion using DMS and SCT

Bu konudan daha fazla soru