1Z0-1094-22 Online Practice Questions and Answers

In order to migrate an active database using RMAN DUPLICATE, what information do you need for the source database? (Choose two.)

A. Location of audit files

B. Listener port

C. Value of the UNDO_RETENTION parameter

D. Database unique name

E. Password for HR schema

When integrating data from multiple sourcesinto a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables. For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value raue for this parameter to enable this check. At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

A. Primary key was not defined on the target table.

B. The Check Knowledge Module was not set in the physical design.

C. The integration type was not set in the logical design.

D. There were no rows compliant with imposed constraint.

Which are TWObenefits of Extract-Load-Transform (ELT) over traditional Extract- Transform-Load (ETL) architectures? (Choose all correct answers)

A. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.

B. ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.

C. ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

D. Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.

Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?

A. DML

B. ELT

C. SOA

D. ETL

You have a security requirement within your organization to separate your resources. There is a team that supports each resource and theyare not allowed access to the other resources.

Which security control with Oracle Cloud Infrastructure meets this requirement?

A. Tagging

B. Compartments and Policies

C. Key Management

D. Federation

You have decided to use Oracle Data Integrator (ODI) on Marketplace to load data from an onpremises Oracle Database toAutonomous Database on Oracle Cloud Infrastructure (OCI). Which TWO methods can be used to connect to the on-premises Oracle Database from OCI? (Choose all correct answers)

A. Oracle directory

B. VPN Connect

C. Terminal service

D. Fast connect

Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)?(Choose all correct answers)

A. Enterprise Scheduler Service (ESS) SOAP API

B. Universal Content Management

C. BI Application Configuration Manager

D. REST API

E. Cloud Connector

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

A. Both Physical and Logical Migration is supported.

B. ZDM does not support Inflight Upgrade.

C. Logical Migration only

D. Physical Migration only

Which statement is true?

A. One PDB consists of only one CDB.

B. One CDB canhave only one PDB.

C. One PDB consists of multiple CDBs.

D. One CDB can have one or more PDBs.

You encounter error ORA-00245 while performing ZeroDowntime Migration of an Oracle RAC database. What might be the reason for this?

A. The RAC instances are running in Archivelog mode.

B. Port 1521 is open.

C. TDE Wallet is configured.

D. SNAPSHOT CONTROL is not pointing to a shared location on all OracleRAC instances.

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

A. Data Pump

B. Data Guard

C. GoldenGate

D. Recovery Manager

What TWO ways does Data Pump use to move data to the cloud? (Choose all correct answers)

A. RMAN Backup and Restore

B. pdb unplug/plug

C. import over Oracle Database database link

D. import dump file from OCI Object Storage

Which FOUR Oracle Data Pump impdp parameters should you use when migrating to Autonomous Database? (Choose all correct answers)

A. TRANSFORN PORTABLE=ALWAYS

B. TRANSFORN=SEGMENT_ATTRIBUTES:N

C. TRANSFORM=CONSTRAINT_USE_DEFAULT_INDEX:Y

D. TRANSFORN=DWCS_CVT_IOTS:Y

E. REMAP_TABLESPACE=DATA

F. REMAP_SCHEMA=SYSTEM

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

A. Logical online or offline migration using a database link

B. Logical online or offline migration using OCI Object Storage

C. Physical online or offline migration using OCI Object Storage

D. Physical online or offline migration using a database link

Which of these provide Active Replication? (Choose two.)

A. Flashback

B. Active Data Guard

C. Sharding

D. GoldenGate