Skip to main content

1Z0-1094-22 Real Exam Questions

Oracle Cloud Database Migration and Integration 2022 Professional

90 questions available · Page 1 of 9

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

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

  1. A

    TABLES_AS_VIEWS

  2. B

    SUBSET_AS_TABLES

  3. C

    VIEWS_AS_TABLES

  4. D

    MATERIALIZED_VIEWS

Show answer and explanation

Correct answer: C

Question 2 Multiple choice

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)

  1. A

    In-Memory Engine

  2. B

    BI Cloud Connector

  3. C

    Oracle (ADW)

  4. D

    File

  5. E

    Object Storage

Show answer and explanation

Correct answers: B, D, E

Question 3 Single choice

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

  1. A

    Both Physical and Logical Migration is supported.

  2. B

    ZDM does not support Inflight Upgrade.

  3. C

    Logical Migration only

  4. D

    Physical Migration only

Show answer and explanation

Correct answer: C

Question 4 Multiple choice

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

  1. A

    It supports cross-endian formats

  2. B

    Both the source and target database mustbe of the same version

  3. C

    It supports cross-platform migration

  4. D

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

Show answer and explanation

Correct answers: A, C

Question 5 Single choice

What is the managed chatbot service of Oracle Cloud called?

  1. A

    Digital Bot

  2. B

    Digital Integration

  3. C

    Digital Support

  4. D

    Digital Assistant

Show answer and explanation

Correct answer: D

Question 6 Single choice

Which file types can be imported using SQL Developer Web?

  1. A

    All of the options

  2. B

    Excel

  3. C

    AVRO

  4. D

    CSV Delimited

  5. E

    JSPN

Show answer and explanation

Correct answer: A

Question 7 Single choice

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?

  1. A

    Consistent

  2. B

    Application Base

  3. C

    Complex

  4. D

    Simple

Show answer and explanation

Correct answer: A

Question 8 Single choice

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

  1. A

    Autonomous Transaction Processing

  2. B

    Autonomous JSON Database

  3. C

    Autonomous Data Warehouse

  4. D

    Autonomous APEX Service

Show answer and explanation

Correct answer: C

Question 9 Single choice

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

  1. A

    1521

  2. B

    22

  3. C

    1680

  4. D

    443

Show answer and explanation

Correct answer: D

Question 10 Multiple choice

When migrating an Oracle database, you must be aware of source and target requirements.
Which TWO statements are true about using Oracle Zero DowntimeMigration (ZDM)?
(Choose all correct answers)

  1. A

    Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.

  2. B

    Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated toEnterprise Edition Databases.

  3. C

    When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.

  4. D

    Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.

Show answer and explanation

Correct answers: A, D