AWS Certified Solutions Architect Professional SAP-C02 Practice Question
An on-premises 50 TB Oracle 12c OLTP database supports a 24×7 trading application. The company must migrate the database to Amazon RDS for Oracle. Application cutover cannot exceed 60 minutes, and the database must remain fully writable until cutover. The data-center's dedicated network link to AWS is limited to 500 Mbps and cannot be upgraded. The migration team wants to minimize network utilization during the bulk load phase while meeting the outage target.
Which migration approach best satisfies these requirements while placing the smallest possible load on the 500 Mbps link?
Configure Oracle Data Guard to replicate to an Oracle Enterprise Edition instance on Amazon EC2 over the 500 Mbps link, then snapshot the EC2 instance and restore it into Amazon RDS for Oracle before cutover.
Use AWS Database Migration Service (AWS DMS) with a replication instance in the AWS Region to perform a full load and ongoing CDC across the existing 500 Mbps link.
Use AWS Snowball Edge integrated with AWS DMS to perform the initial bulk load locally, ship the device to AWS, and then resume the same AWS DMS task in CDC mode to Amazon RDS for Oracle until cutover.
Use AWS DataSync to copy Oracle RMAN backup files to Amazon S3 and restore the backup into Amazon RDS for Oracle during the 60-minute outage.
Shipping the bulk data on an AWS Snowball Edge off-loads almost all of the 50 TB initial transfer from the constrained 500 Mbps circuit. When the device reaches AWS, the same AWS DMS task automatically resumes, performs the full load into Amazon RDS for Oracle, and uses change data capture (CDC) to stream only ongoing changes across the network. Because the CDC traffic is a fraction of the 50 TB bulk load, the link is not a bottleneck and cutover can be completed in well under the 60-minute window.
A full load plus CDC performed entirely over the 500 Mbps link would take roughly 9-10 days just for the full load, far exceeding the downtime requirement. AWS DataSync copies files or objects and can't apply redo or CDC, so the database would have to be taken offline for the entire restore. Oracle Data Guard over the same 500 Mbps link would still need to transmit the entire 50 TB of redo, and snapshotting an EC2 database to restore into RDS is not a supported, low-downtime path. Therefore, using AWS Snowball Edge with AWS DMS for the initial load and CDC replication is the only option that meets all constraints.
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 Snowball Edge and how does it help in data migration?
Open an interactive chat with Bash
What does Change Data Capture (CDC) mean in AWS DMS?
Open an interactive chat with Bash
Why doesn't Oracle Data Guard or using the 500 Mbps link directly meet the requirements?
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