Oracle Cloud Database 2023 Migration and Integration Professional

Question 1

Oracle Zero Downtime Migration (ZDM) uses MySQL internally, configuring on a default port number. What will ZDM proceed to, if a port number is not specified and the default is not available?

A. Request a valid port number

B. Increase the default port number by one and retry five times.

C. Assign a random port number.

D. Exit the installation with an error message.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers)

A. Physical online or offline migration using OCI Object Storage

B. Physical online or offline migration using a database link

C. Logical online or offline migration using OCI Object Storage

D. Logical online or offline migration using a database link

Correct Answer: A,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Which TWO statements are true about the Oracle Zero Downtime command line? (Choose all correct answers)

A. The -sourcedb option is the only valid option to indicate the source database name.

B. When the source database is a single instance database deployed on a non-Grid Infrastructure environment, the sourcesid option should be used to specify the database name.

C. Upon executing the zdmcli, migrate database command, the only way to track the status of the migration is by querying the ZDM service using the provided job ID.

D. The zdmeli migrate database command can be run with no options as long as all the information is correctly specified in Zero Downtime Migration's (ZDM) response file.

Correct Answer: B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?

A. UNDO

B. SYSTEM

C. USERS

D. DATA

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

When preparing for a migration using RMAN DUPLICATE from an active database, which two actions do you need to take if the on-premises database (DB) is Transparent Data Encryption (TDE) encrypted?

A. Copy the encryption wallet from the on-premises DB to the Cloud DB System.

B. Use the dbcli dbstorage command to identify the DATA, RECO, and REDO locations.

C. Perform an RMAN backup of the on-premises DB to OCI Cloud Storage.

D. Make sure that the SYS user password is identical on both systems.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?

A. sa_audit_admin

B. Dbms_cloud_macadm

C. Dbms_cloud

D. Dbms_cloud_admin

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

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

A. PARALLEL

B. FLASHBACK_TIME

C. LOGTIME

D. METRIC

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

Which statements are true for OCI GoldenGate Service? (Choose two.)

A. It is customer-managed.

B. It requires any source environment to run Oracle GoldenGate Microservices.

C. It requires an on-premises license for the Oracle GoldenGate software.

D. It supports the usage of Universal Credits.

Correct Answer: A,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Cloud Database 2023 Migration and Integration Professional - 1z0-1094-23 Exam Practice Test

Latest Update

Useful Links

Contact Us