Oracle Cloud Database Migration and Integration 2022 Professional

QUESTION NO: 1
Which developer tool can be used to load JSON documents to an Oracle database on the cloud?

A. SQL Developer Web B. SQL Developer C. Modeler D. REST Data Services

Correct Answer: A

QUESTION NO: 2
Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers)

A. Oracle Zero Downtime Migration B. Data Pump Export/lmport C. Data Guard D. Enterprise Manager E. PDB Unplugging/Plugging

Correct Answer: A,B,D

QUESTION NO: 3
In which database edition does Data Pump support parallelism?

A. Enterprise Edition only B. Data Pump does not support parallelism. C. Both Standard Edition and Enterprise Edition D. Standard Edition only

Correct Answer: A

QUESTION NO: 4
Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database? (Choose all correct answers)

A. Recovery Manager B. Data Pump C. GoldenGate D. Data Guard

Correct Answer: B,C

QUESTION NO: 5
You are migrating a non TDE encrypted on-premises Database to an OCT Database Service Instance ising RMAN. You set up the DB Cloud Backup Module, but when executing the RMAN command to create your Cloud Backup you see the following error: AANA RMAN-03009: failure of backup command on ORA_SBT_TAPE 1 channel at: 08/18/2014 11: ORA-19914: unable to encrypt backup ORA~29361 mastor key not yet set What are the TWO causes of this error? (Choose all correct answers)

A. The set DECRYPTION IDENTIFIED BY RMAN command was not executed. B. SET ENCRYPTION ON C. The Set ENCRYPTION IDENTIFIED BY command was executed. D. The Set ENCRYPTION IDENTIFIED BY only command was executed E. He OCT Object Storage eye on at rest key is missing

Correct Answer: B,C

QUESTION NO: 6
Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?

A. FLASHBACK_TIME B. METRIC C. LOGTIME D. PARALLEL

Correct Answer: A

QUESTION NO: 7
You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI). Which statement is true?

A. You can join table A and table B, as required by the data model and load target C in a Single mapping B. You are required to do inner join between table A and table B in order to load target C. A mapping can have only one source and one target. You need to create 2 mappings to load target C. D. You are required to do outer join between table A and table B in order to load target C.

Correct Answer: A

QUESTION NO: 8
In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?

A. TNSNAMES.ORA B. WALLET.ORA C. SQLNET.ORA D. LISTENER.ORA

Correct Answer: C

QUESTION NO: 9
When selecting a migration method for moving your database to the cloud, what would you NOT take into consideration?

A. High Availability B. Schema Name C. Database Size D. Database Version

Correct Answer: B

QUESTION NO: 10
Which type of autonomous database will you create for decision support systems that run fast queries over large volumes of data?

A. Autonomous Transaction Processing B. Autonomous Data Warehouse C. Autonomous APEX Service D. Autonomous JSON Database

Correct Answer: B

Oracle Cloud Database Migration and Integration 2022 Professional - 1z0-1094-22 Exam Questions