Oracle Cloud Infrastructure 2019 Architect Associate — Question 6

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

Answer options

• A. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
• B. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
• C. Data Pump is faster to migrate database than using RMAN.
• D. Data Pump creates the tablespaces used by your Autonomous Database.

Correct answer: A, B

Explanation

Option A is correct because Data Pump allows for selective migration, omitting unnecessary objects. Option B is also correct since Data Pump is designed to work across various platforms. Options C and D are incorrect; while Data Pump is efficient, RMAN has its own advantages, and it does not create tablespaces in Autonomous Database.