1Z0-997-25 Question 152
Single answerYou are a solutions architect for a manufacturing company planning to migrate a 2 TB on-premises Oracle Database to an Autonomous Database on Oracle Cloud Infrastructure (OCI). The team intends to use the Oracle Database Migration Service (DMS) to minimize downtime and simplify the transition. Before initiating the migration, which action is most critical to ensure the service can access and migrate data successfully?
- A
Create a public load balancer in OCI and forward all inbound traffic from on-premises to the target Autonomous Database.
- B
Open the necessary ports on the on-premises firewall to allow communication from the DMS private endpoint to the source database.
- C
Enable local Data Pump exports on the on-premises database and manually upload the dump files to OCI Object Storage.
- D
Configure Oracle Data Guard on the on-premises database to replicate changes to the target Autonomous Database.
Show answer and explanation
Correct answer: B
Explanation
Before using Oracle Database Migration Service to move an on-premises Oracle Database to OCI, you must ensure that the service can securely connect to the source database. Opening the correct ports on your on-premises firewall and verifying network access is crucial to enable DMS to perform the migration steps, including initial data load and ongoing synchronization if needed. For further details, refer to the official Oracle Documentation section on 'Oracle Database Migration Service' at https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/dms.htm.
- A. Incorrect.
Option 1 is incorrect because creating a public load balancer for database traffic is neither secure nor recommended for data migrations. The Oracle Database Migration Service uses private endpoints or secure connections, and a public load balancer is not required for DMS to access the on-premises source database.
- B. Correct.
Option 2 is correct. Ensuring that the on-premises firewall rules allow inbound connectivity from the DMS private endpoint to the source database is critical; without this, the service cannot connect, extract data, or manage the migration process. Proper network configuration is a primary consideration when setting up data migrations in OCI.
- C. Incorrect.
Option 3 is a partial solution but not the most critical step for the Oracle DMS setup. While Data Pump exports and manually uploading dump files to Object Storage can be used in certain use cases, it introduces additional overhead and does not ensure that DMS can directly access and migrate the live database with minimal downtime.
- D. Incorrect.
Option 4 is incorrect because configuring Oracle Data Guard for your on-premises database is not a required step when using Oracle Database Migration Service. DMS relies on direct connectivity and built-in migration steps rather than Data Guard-based replication to achieve minimal downtime.