Oracle Cloud Infrastructure 2020 Architect Professional — Question 13

You are responsible for migrating your on-premises legacy databases on 11.2.0.4 version to Autonomous Transaction Processing "" Dedicated (ATP""D) in Oracle
Cloud Infrastructure (OCI). As a solution architect, you need to plan your migration approach.
Which two options do you need to implement together to migrate your on-premises databases to OCI? (Choose two.)

Answer options

• A. Use Oracle GoldenGate replication to keep on-premises database online during migration.
• B. Convert on-premises databases to PDB, upgrade to 19c, and encrypt.
• C. Use Oracle Data Guard to keep on-premises database always active during migration.
• D. Retain changes to Oracle shipped privileges, stored procedures or views in the on-premises databases.
• E. Retain all legacy structures and unsupported features (e.g. legacy LOBs) in the on-premises databases for migration.

Correct answer: A, B

Explanation

Option A is correct as Oracle GoldenGate allows for real-time data replication, enabling the on-premises database to remain available during the migration process. Option B is also correct because converting to PDBs, upgrading to 19c, and encrypting the databases are essential steps for compatibility and security in the cloud environment. Options C, D, and E are not suitable for this scenario; Data Guard is not a primary migration tool, and retaining unsupported features and modifications could complicate the migration process.