[Jul 12, 2023] Latest Database Cloud Service 1z0-1094-22 Actual Free Exam Questions [Q41-Q62] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NO.41 If unplug and plug was decided to be used as the tool for the migration to Oracle Cloud Infrastructure (OCD), which two constraints are part of this migration to process for using unplug and plug? (Choose all correct answers)

Target must be an Autonomous database.

Source and target need to be container database (CDB).

Target and source have same Endianness.

Source must be Little-endian.

NO.42 Which TWO statements are true about online pluggable database (PDB) relocation? (Choose all correct answers)

Database version downgrade can be achieved with PDB relocation.

A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.

PDB relocation with no version change can be performed with near-zero downtime.

Online PDB relocation can achieve a zero downtime upgrade.

NO.43 Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)

RMAN CONVERT

RMAN DUPLICATE

RMAN RESTORE from target

RMAN Transportable Tablespaces with Data Pump

NO.44 Which database version introduced Zero Downtime online logical migration?

Oracle Database 18c

Oracle Database 19c

Oracle Database 12c

Oracle Database 21c

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

118

1521

443

NO.46 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

NO.47 Which parameter can be used to export a subset of data using Data Pump?

TABLES_AS_VIEWS

MATERIALIZED_VIEWS

SUBSET_AS_TABLES

VIEWS_AS_TABLES

NO.48 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

NO.49 You run a database instance on Oracle Database 11.2 and you want to migrate to Oracle Cloud. In which case is it required to upgrade your source database before migrating to the cloud?

if you are using unplug/plug

if you are using Recovery Manager (RMAN)

if you are using virtual machines

if your target is Exadata Cloud Service

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

UNDO

SYSTEM

DATA

USERS

NO.51 In which database edition does Data Pump support parallelism?

Enterprise Edition only

Standard Edition only

Both Standard Edition and Enterprise Edition

Data Pump does not support parallelism.

NO.52 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 )

NO.53 Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?

Oracle Autonomous Database

Oracle Exadata

Oracle 19c

Oracle MySQL Cloud Service

NO.54 You need to migrate your on-premises 12c Non CDB to Cloud 12c. Which migration methods can you use? (Choose two.)

Conventional RMAN Backup and Recovery

Transportable Tablespaces

Conventional Data Pump Export and Import

Transportable Databases

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

ppms_cLoup_aDMIN

pems_croup

sa_aupiT_ADMIN

pams_cnoup_MacapM

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

Digital Support

Digital Bot

Digital Assistant

Digital Integration

NO.57 Which are TWO benefits of Extract-Load-Transform (ELT) over traditional Extract-Transform-Load (ETL) architectures? (Choose all correct answers)

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

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

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

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

NO.58 Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.)

RMAN

Oracle GoldenGate

Data Guard

Data Pump

NO.59 In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?

FORCE

NOMOUNT

OPEN

MOUNT

NO.60 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

NO.61 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?

Isolation host

Private host

Encrypted host

Baston host

NO.62 You have an on-premises non-TDE-encrypted Linux 19c container database (CDB) that is already being regularly backed up to Oracle Cloud Infrastructure (OCI) Object Storage via the Database Backup Cloud Service. You plan on using Recovery Manager (RMAN) to migrate it to Database Cloud Service. What is the valid strategy to migrate?

Create a new OCI DB Service instance, delete the existing database, and use the DBaa$ tooling to configure the DB Cloud Backup Module to point to the existing bucket, and then restore the backup by using the console.

Create a new OCI DB Service Instance, copy the backup data from the bucket to the FRA, and then use the console to perform a DB restore.

Create a new DB Service instance, delete the existing database, manually install the DB Cloud Backup Module pointing it to the backed where the on-premises backups are located, and perform a complted RMAN RESTORE AS encryption operation.

Create a new OCI DB Service instance and use the “instantiate from backup” option in the console. This will automatically take care of the encryption.