[Aug-2023] Database Cloud Service 1z0-1094-22 Exam Practice Dumps [Q50-Q69]

NO.50 What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?

Remote cloning a pluggable database (PDB)

Data Pump Transportable Tablespaces

Data Load tab of the SQL worksheet in Database Actions

RMAN Transportable Tablespace

NO.51 How much network latency is tolerated by the Remote Apply process of Oracle GoldenGate?

4 ms

16 ms

8 ms

6 ms

NO.52 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.53 Which FOUR Oracle Data Pump impdp parameters should you use when migrating to Autonomous Database? (Choose all correct answers)

REMAP_SCHEMA=SYSTEM

TRANSFORN=DWCS_CVT_IOTS:Y

REMAP_TABLESPACE=DATA

TRANSFORM=CONSTRAINT_USE_DEFAULT_INDEX:Y

TRANSFORN=SEGMENT_ATTRIBUTES:N

TRANSFORN PORTABLE=ALWAYS

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

Oracle Database 18c

Oracle Database 19c

Oracle Database 12c

Oracle Database 21c

NO.55 Your data warehouse load consists of extracting data from order header and order line items table. what kind of journalizing type should you use in Oracle Data Integration ( ODI ) to make sure referential integrity is maintained in the target?

Consistent

Application Base

Simple

Complex

NO.56 Which TWO options are valid when using the unplug/plug a PDB method to migrate? (Choose all correct answers)

Target database versions must be 18c or later.

Non-CDB databases can be consolidated and migrated.

Source database versions are 12c or later.

Use this technique to do a cross-endian conversion

NO.57 What does ETL stand for?

Extract Translate and Load

Export Transform and Load

Export Translate and Load

Extract Transform and Load

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

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

users and groups to be migrated

on-premises host operating system

number of tables

character set of databases

NO.60 You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI). Which statement is true?

You are required to do inner join between table A and table B in order to load target

A mapping can have only one source and one target. You need to create 2 mappings to load target C.

You are required to do outer join between table A and table B in order to load target C.

You can join table A and table B, as required by the data model and load target C in a Single mapping

NO.61 Which type of checks is NOT supported by Oracle Data Integrator (ODI)?

references

mandatory attributes

business rule

keys

conditions

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

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

NO.64 Which statement is true?

One CDB can have only one PD

One PDB consists of only one CDB.

One CDB can have one or more PDBs.

One PDB consists of multiple CDBs.

NO.65 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.66 In Zero Downtime Migration, which port number is used by the source and target system to access Object Storage?

118

1521

443

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

NO.68 Which four Oracle Database Cloud Services are supported as a target database using Oracle Zero Downtime Migration?
(Choose all correct answers)

Oracle MySQL Database Cloud Service

Oracle Database Cloud Service

Exadata Cloud at Customer

Autonomous Database

Exadata Cloud Service

oracle NOSQL Database Cloud Service

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

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

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

Latest Exam Prep

[Aug-2023] Database Cloud Service 1z0-1094-22 Exam Practice Dumps [Q50-Q69]

Leave a Reply

1z0-1094-22 Practice Tests

Related Certifications

Recent Posts

Recent Comments

Archives

Categories