Oracle Cloud Infrastructure 2023 Architect Associate — Question 22

The third-party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands such as tablespace names, usernames, and init.ora parameters. The decision was made to adhere to the suggested migration method using an Instant Client and the Data Pump version that was suggested (and came with it).

Which statement is true about the successful migration of the application's database?

Answer options

• A. The migration cannot be a success, using the default Data Pump setup.
• B. The migration can be technically a success, but the third-party vendor needs to support the result.
• C. The tablespace names will result in a blocking error during Data Pump import because of ADB limitations.
• D. The suggested Data Pump version will create an alias for non-standard tablespace names so the migration is successful.

Correct answer: B

Explanation

The correct answer is B because, although the migration can technically be completed, the third-party vendor's support is crucial to ensure that the application functions correctly after the migration. Option A is incorrect because the default Data Pump can still be used, while C is wrong as it assumes a blocking error that may not occur. Option D misrepresents the capabilities of the Data Pump version regarding alias creation for tablespace names.