[Oct-2023] The Best Database Cloud Service Study Guide for the 1z0-1094-22 Exam [Q46-Q70]

Rate this post

[Oct-2023] The Best Database Cloud Service Study Guide for the 1z0-1094-22 Exam

1z0-1094-22 certification guide Q&A from Training Expert ActualCollection

Q46. 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.

Q47. When was SQL Developer Web released?

2018

2006

2011

2016

2009

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

Value of the UNDO_RETENTION parameter

Password for HR schema

Location of audit files

Listener port

Database unique name

Q49. 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

Q50. 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

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

Digital Support

Digital Bot

Digital Assistant

Digital Integration

Q52. Which technologies can you use for Zero Downtime physical migration? (Choose two.) (Choose all correct answers)

Oracle GoldenGate

Data Guard

Data Pump

RMAN

Q53. 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

Q54. 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.

Q55. Which statements are true for Zero Downtime Migration? (Choose two.)

It is a complex process that requires you to raise an SR with Oracle Support.

It does not leverage Oracle MAA best practices.

It ensures zero data loss.

It is free.

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

Tablespaces must be compressed.

Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.

Tablespaces may not be encrypted.

system and sysaux can be migrated cross-endian.

Q57. 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 OCI Object Storage

Physical online or offline migration using a database link

Logical online or offline migration using a database link

Physical online or offline migration using OCI Object Storage

Q58. You have executed the mappings with Change Data Capture ( CDC ) on the source data store and you are now going through the code in the operator log for debugging. Which two tables or view do you need to inspect in the database to see whether the CDC process is writing changed data or not in Oracle Data Integration ( ODI )? (Choose all correct answers)

JW$ view

JV$ view

J$ table

JV$D view

Q59. 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

Q60. Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

network name or IP address of the machine hosting the Oracle Database

listing port of the oracle listener

name of the Oracle Instance (SID) or service

database link

list of all schemas

Q61. 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

Q62. 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.

Q63. You are migrating an on-premises Linux 11.2.0.4 Database to a Database Cloud Service by using the Cross-Platform Transportable Tablespace Backup Set. Which statement is true?

FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4.

The Database Cloud Service target version must be 11.2.0.4.

The Database Cloud Service target version must be 12.1 or later.

The Database Cloud service target iS a container database (CDB).

Q64. 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.

Q65. 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

Q66. 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

Q67. You have decided to use Oracle Data Integrator (ODI) on Marketplace to load data from an onpremises Oracle Database to Autonomous 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)

Terminal service

VPN Connect

Fast connect

Oracle directory

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

Active Data Guard

Sharding

GoldenGate

Flashback

Q69. When selecting a migration method for moving your database to the cloud, what would you NOT take into consideration?

Schema Name

Database Size

High Availability

Database Version

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

gg_lag

ogg_latency

Lag_view

goldengate_lag

The Best Oracle 1z0-1094-22 Study Guides and Dumps of 2023: https://www.actualcollection.com/1z0-1094-22-exam-questions.html

Leave a comment Cancel reply