nerdexam
Oracle

1Z0-931-20 · Question #69

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…

The correct answer is A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps. C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer D. SQL Developer can only export/move/import files using datapump from databases running on Linux. See the full explanation below for the reasoning.

Question

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.)

Options

  • ASQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
  • BSQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3
  • CSQL Developer can import .csv files into ADB which are located on the system where SQL Developer
  • DSQL Developer can only export/move/import files using datapump from databases running on Linux

How the community answered

(33 responses)
  • A
    73% (24)
  • B
    27% (9)

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice