Oracle Cloud Database 2023 Migration and Integration Professional v1.0 (1z0-1094-23)

Page:    1 / 4   
Total 54 questions

You are creating a data integration mapping in Oracle Data Integrator (ODI). Your source tables are in an on-premises Oracle Database.
Which three items from the source tables can be retrieved by reverse-engineering a model? (Choose three.)

  • A. Constraints
  • B. Column names
  • C. Data types
  • D. Table owner
  • E. Table Statistics


Answer : ABC

Your source tables are in an on-premises Oracle Database. You have created the data server and logical schema in an Oracle Data Integrator (ODI) topology.
Now you are ready to start reverse engineering and create mappings.
Which two Knowledge Modules (KM) need to be imported to your project for the Oracle Database source? (Choose two.)

  • A. LKM SQL to MSSQL
  • B. IKM XML Control Append
  • C. RKM Oracle
  • D. CKM HSQL
  • E. LKM SQL to Oracle


Answer : CE

In Oracle Zero Downtime Migration (ZDM), the migrate database command provides several options to ensure a successful Oracle source and target data migration.
Which four are valid parameters to use with migrate database? (Choose four.)

  • A. -sourcedb
  • B. -sourcesid
  • C. -dbpatchlevel
  • D. -dbversion
  • E. -tdemasterkey
  • F. -tgtroot


Answer : ACEF

How can you properly pause a Zero Downtime Migration (ZDM) job?

  • A. By executing the zdmcli -pausejob command at any time
  • B. By executing the zdmcli migrate database command with the -pauseafter option, alongside specifying the relevant migration phase where ZDM should pause the migration process,
    or by executing the zdmcli suspend job -jobid command at anytime during the migration
  • C. By executing the zdmcli migrate database command using the -pause option
  • D. By querying the ZDM service host with the relevant job ID and executing the zdmcli -pausejob command


Answer : B

Your source database version is 12c and your target database is ATP-D.
Which utility should you use to instantiate the target database?

  • A. Datafile Copy to Object Storage
  • B. Oracle RMAN Duplicate Database
  • C. Oracle Data Pump
  • D. SQL Developer Migration Wizard


Answer : C

When configuring the GoldenGate Hub, what is the default port opened in the compute instance Virtual Cloud Network (VCN) security list to allow access to the GoldenGate deployments through the Nginx reverse proxy server?

  • A. 22
  • B. 8080
  • C. 1521
  • D. 443


Answer : D

Which statement is NOT true about the multitenant (container database) architecture of Oracle Database?

  • A. The background processes are shared between PDBs.
  • B. The SGA is shared between PDBs.
  • C. The redo log files are shared between PDBs.
  • D. The data flies are shared between PDBs.


Answer : D

Which two statements are true about online pluggable database (PDB) relocation? (Choose two.)

  • A. PDB relocation with no version change can be performed with near-zero downtime.
  • B. PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.
  • C. Online PDB relocation can achieve a zero downtime upgrade.
  • D. Database version downgrade can be achieved with PDB relocation.


Answer : AB

You have a security requirement within your organization to separate your resources. There is a team that supports each resource and they are not allowed access to the other resources.
Which security control feature of Oracle Cloud Infrastructure meets this requirement?

  • A. Key Management
  • B. Tagging
  • C. Compartments and Policies
  • D. Federation


Answer : C

When building out your private subnet, you realize you need a host within your network in order to get access to the rest of your Oracle Cloud Infrastructure instances.
Which type of host should you set up to get around this constraint?

  • A. Encrypted host
  • B. Isolation host
  • C. Bastion host
  • D. Private host


Answer : C

Which platform and version supports the deployment of Oracle Zero Downtime Migration Service host?

  • A. Oracle Linux 7
  • B. Windows 2012 R2 and 2016 R1
  • C. IBM AIX 7.1 and later
  • D. Red Hat Enterprise Linux 8.2
  • E. Solaris 11 Update 3 and later


Answer : A

Which three backup mediums are supported when migrating a database with Oracle Zero Downtime Migration? (Choose three.)

  • A. Oracle Zero Data Loss Recovery Appliance
  • B. NFS Storage
  • C. Tape Storage
  • D. Oracle Cloud Infrastructure Object Storage


Answer : ABD

Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow? (Choose three.)

  • A. Oracle Data Guard
  • B. Oracle Real Application Testing
  • C. Streams
  • D. Recovery Manager (RMAN)
  • E. SQL*Net


Answer : ADE

Which three supported platforms can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration (ZDM)? (Choose three.)

  • A. HP-UX
  • B. Solaris
  • C. Linux x86-64
  • D. AIX
  • E. Windows


Answer : BCD

You are planning to migrate a large data center to Oracle Cloud while also trying to consolidate many Oracle Databases at the same time.
Which Oracle Data Management Service helps you achieve this?

  • A. Oracle Autonomous Database
  • B. Oracle Data Safe
  • C. Oracle Exadata Cloud Service
  • D. Oracle MySQL Cloud Service


Answer : C

Page:    1 / 4   
Total 54 questions