Oracle Cloud Infrastructure 2019 Architect Associate — Question 24

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating
(access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

Answer options

• A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
• B. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
• C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
• D. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

Correct answer: A, C, D

Explanation

The correct answer A is true because SQL Developer provides a streamlined wizard for migrating databases to ADB. Option C is also correct as SQL Developer can import .csv files directly from the local system. Option D is incorrect; SQL Developer is not limited to just Linux systems for exporting or importing, as it can work across various platforms.