Get Aug-2023 updated Exam 1z0-1094-22 Dumps with New Questions [Q37-Q59] – IT Certification Exam Questions & Answers

Rate this post

Get Aug-2023 updated Exam 1z0-1094-22 Dumps with New Questions

100% Pass Guarantee for 1z0-1094-22 Exam Dumps with Actual Exam Questions

NEW QUESTION 37
Which knowledge modules are supported by Oracle Data Integrator (ODI)?

ADW

All of the options

Hive

Spark

IDB DB2

NEW QUESTION 38
Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud? (Choose all correct answers)

FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)

metrics=yes (for Diagnostics)

parameter=1 (for performance)
logtime=all (for Diagnostics)

versron=10 (for compatibility)
exclude=statistics (for performance

NEW QUESTION 39
Which file types can be imported using SQL Developer Web?

AVRO

CSV Delimited

Excel

All of the options

JSPN

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

It supports the usage of Universal Credits.

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

It is customer-managed.

It requires any source environment to run Oracle GoldenGate Microservices.

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

SQLNET.ORA

WALLET.ORA

TNSNAMES.ORA

LISTENER.ORA

NEW QUESTION 42
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)

The Set ENCRYPTION IDENTIFIED BY only command was executed

SET ENCRYPTION ON

The Set ENCRYPTION IDENTIFIED BY command was executed.

He OCT Object Storage eye on at rest key is missing

The set DECRYPTION IDENTIFIED BY RMAN command was not executed.

NEW QUESTION 43
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 with Oracle Cloud Infrastructure meets this requirement?

Compartments and Policies

Key Management

Tagging

Federation

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

PARALLEL

METRIC

LOGTIME

FLASHBACK_TIME

NEW QUESTION 45
You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.

Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load.

Flat file data has to have a header row in order to join with Oracle database table in a single mapping

It is not possible to join data from different source connection types in a Single mapping

It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.

NEW QUESTION 46
When integrating data from multiple sources into 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?

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

There were no rows compliant with imposed constraint.

Primary key was not defined on the target table.

The integration type was not set in the logical design.

NEW QUESTION 47
Which migration method gives you the least down time?

Data pump

RMAN point-in-time recovery

Transportable Tablespaces

Data Guard

NEW QUESTION 48
Which statements are true about Data Pump? (Choose two.)

Both the source and target database must be of the same version

It supports cross-platform migration

A best practice is to invoke Data Pump using SYS as SYSDBA

It supports cross-endian formats

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

Data Pump

Recovery Manager

Data Guard

GoldenGate

NEW QUESTION 50
Which of these can be used to unload and load data via Data Pump? (Choose two.)

Network mode (with database links)

Dumpfile

Streamfile

Backupset

NEW QUESTION 51
What is the managed chatbot service of Oracle Cloud called?

Digital Support

Digital Bot

Digital Assistant

Digital Integration

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

sa_audit_admin

Dbms_cloud_macadm

Dbms_cloud_admin

Dbms_cloud

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

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.

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.

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.

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

NEW QUESTION 54
Which autonomous database types are available on Oracle Cloud? (Choose three.)

Autonomous Relation Database System

Autonomous Transaction Processing

Autonomous JSON Database

Autonomous Streams

Autonomous Data Warehouse

NEW QUESTION 55
Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?

Linux x86-64

windows

aix

Solaris

NEW QUESTION 56
Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration? (Choose all correct answers)

Oracle Database 11g Release 2 ( 11.2.0.4 )

Oracle Database 19

Oracle Database 11g Release 2 ( 11.2.0.3 )

Oracle Database 10 g Release 2

Oracle Database 12c Release 1 ( 12.1.0.2)

Oracle Database 12c Release 2 ( 12.2.0.1 )

NEW QUESTION 57
Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)

Database Cloud service Bare Metal

Infrastructure as a service

Exadata Cloud Service

Autonomous Database

NEW QUESTION 58
Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers)

ZDM_BASE group access enabled

Root user or SSH key-based access to source database server

Root user or SSH key-based access to target database server

Jmx connections to be accepted from multiple hosts

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

Autonomous JSON Database

Autonomous Transaction Processing

Autonomous Data Warehouse

Autonomous APEX Service

Loading …