Regular Free Updates 1Z0-1094-21 Dumps Real Exam Questions Test Engine Nov 24, 2022 [Q47-Q65]

Rate this post

Regular Free Updates 1Z0-1094-21 Dumps Real Exam Questions Test Engine Nov 24, 2022

Practice Test Questions Verified Answers As Experienced in the Actual Test!

Q47. 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)

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

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

metrics=yes (for Diagnostics)

Q48. 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?

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 mix heterogeneous source connection type and load into any supported target connection type 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.

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

Autonomous Database

Database Cloud service Bare Metal

Infrastructure as a service

Exadata Cloud Service

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

TRANSFORN PORTABLE=ALWAYS

TRANSFORN=SEGMENT_ATTRIBUTES:N

TRANSFORM=CONSTRAINT_USE_DEFAULT_INDEX:Y

TRANSFORN=DWCS_CVT_IOTS:Y

REMAP_TABLESPACE=DATA

REMAP_SCHEMA=SYSTEM

Q51. Which three backup mediums are supported when migrating a database with oracle zero downtime migration?.
(Choose all correct answers)

Oracle Cloud Infrastructure Object Storage

Third-Party Cloud Storage

Oracle Zero data loss recovery appliance

NFS Storage

Tape Storage

Q52. What is the managed chatbot service of Oracle Cloud called?

Digital Bot

Digital Integration

Digital Support

Digital Assistant

Q53. Which TWO statements are true about cross-endian migration using Transportable Tablespaces? (Choose all correct answers)

Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.

system and sysaux can be migrated cross-endian.

Tablespaces may not be encrypted.

Tablespaces must be compressed.

Q54. What are the constraints of using transportable tablespaces? (Choose two.)

The source and target database versions must match.

The source and target time zone versions must match.

The source and target platforms must match.

The source and target character sets must match.

Q55. Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose all correct answers)

an operation on a model, sub model, or a data store, such as a customized reverse-engineering or a journalizing operation

the execution of a runtime scenario or a Load plan that was launched from the Oracle Data Integrator Studio, from a command line, via a schedule or a web service interface

setting up an FTP server as a staging location for extracted data

the execution of a design-time object, such as a mapping, a package or a procedure backing up data warehouse destination objects before loading the transformed data

Q56. Which migration method gives you the least down time?

Data Guard

RMAN point-in-time recovery

Transportable Tablespaces

Data pump

Q57. 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?

Tagging

Federation

Compartments and Policies

Key Management

Q58. You are using Oracle Data Integrator (ODI). Which three topology elements are required to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

In-Memory Engine

BI Cloud Connector

Oracle (ADW)

File

Object Storage

Q59. Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?

users and groups to be migrated

on-premises host operating system

character set of databases

number of tables

Q60. Which port number do all the OCI GoldenGate Microservices environments use for port forwarding through NGINX?

1521

1680

443

Q61. Which file types can be imported using SQL Developer Web?

All of the options

Excel

AVRO

CSV Delimited

JSPN

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

Logical online or offline migration using a database link

Logical online or offline migration using OCI Object Storage

Physical online or offline migration using OCI Object Storage

Physical online or offline migration using a database link

Q63. Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?

gg_lag

goldengate_lag

ogg_latency

Lag_view

Q64. In Zero Downtime Migration, which port number is used by the source and target system to access Object Storage?

443

1521

118

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

Location of audit files

Listener port

Value of the UNDO_RETENTION parameter