AWS Certified Solutions Architect Professional SAP-C02 Practice Question
A company hosts a 40-TB Oracle 11g database in its on-premises data center. The database must be migrated to Amazon RDS for Oracle with less than 10 minutes of application downtime. The only network connectivity to AWS is a 200-Mbps dedicated internet link, and increasing bandwidth is not an option. The migration team wants to use managed AWS services and minimize operational overhead during the migration.
Which approach will meet these requirements?
Use AWS Schema Conversion Tool (AWS SCT) with its DMS replication agent to copy the initial data to an AWS Snowball Edge device, ship the device to AWS to load the data into Amazon S3, and then use AWS DMS to perform ongoing CDC replication over the network until cutover to the RDS DB instance.
Export the database to RMAN backup files, upload the files to Amazon S3 using S3 Transfer Acceleration, restore them into RDS for Oracle, and then create an AWS DMS CDC-only task to synchronize changes.
Use AWS Database Migration Service (AWS DMS) to run a full-load plus ongoing replication (CDC) task from the on-premises database directly to the RDS DB instance across the existing link. Size the replication instance appropriately and enable parallel load.
Configure Oracle Data Guard physical standby across a VPN tunnel to an RDS Multi-AZ DB instance and perform a switchover when lag is less than 10 minutes.
Copying the bulk of the data to an AWS Snowball Edge avoids sending 40 TB across a 200-Mbps link, eliminating the main bottleneck. AWS SCT drives the bulk load onto the Snowball and creates the AWS DMS task. After the device is ingested into Amazon S3, the same DMS task switches to change-data-capture mode and streams only incremental changes over the existing 200-Mbps link until cutover, allowing the application to be offline for only a few minutes.
A network-only DMS full load would take many days at 200 Mbps, so it cannot meet the downtime objective. Oracle Data Guard cannot be configured between an on-premises database and Amazon RDS for Oracle, so a switchover is not possible. Uploading RMAN backups over S3 Transfer Acceleration still relies on the same limited link and restoring RMAN into RDS for Oracle is unsupported, so the initial load window would be missed.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is AWS SCT and how does it help in database migrations?
Open an interactive chat with Bash
What is AWS DMS’s Change Data Capture (CDC) feature, and why is it important?
Open an interactive chat with Bash
How does AWS Snowball Edge address the limitations of network bandwidth for data transfer?
Open an interactive chat with Bash
AWS Certified Solutions Architect Professional SAP-C02
Accelerate Workload Migration and Modernization
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
IT & Cybersecurity Package Join Premium for Full Access