Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Oracle Data Integrator 12c Certified Implementation Spe
  4. 1z0-448 - Oracle Data Integrator 12cEssentials

Oracle 1z0-448 Oracle Data Integrator 12cEssentials Exam Practice Test

Demo: 11 questions
Total 79 questions
Get 1z0-448 Full Access Download 1z0-448 PDF

Oracle Data Integrator 12cEssentials Questions and Answers

Question 1

You design a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this? (Choose the best answer.)

Options:

A.

Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.

B.

Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.

C.

Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.

D.

Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.

Question 2

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.)

Options:

A.

from the source database into flat files that are then loaded into the target database

B.

directly from the source database to the target database

C.

from the source database onto the server running the Agent and then into the target database

D.

from the source database into the machine running ODI Studio and then into the target database

Question 3

Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.)

Options:

A.

odiMasterRepository

B.

MasterRepository

C.

odimasterrepository

D.

ODIMasterRepository

Question 4

A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.

In which database schema must you look to find this table? (Choose the best answer.)

Options:

A.

the schema hosting the Work repository

B.

the schema hosting theWork schema of the default schema defined for your source data server

C.

the schema hosting the Staging Area

D.

SYS

Question 5

You want to override the code generated by ODI and provide a custom SQL statement as the source of a Mapping. How must you proceed? (Choose the best answer.)

Options:

A.

Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.

B.

Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.

C.

In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfield.

D.

Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.

Question 6

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

Options:

A.

Run Exception and Restart

B.

Run Exception and Continue

C.

Run Exception and Ignore

D.

Run Exception and Fail

E.

Run Exception and Raise

Question 7

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

Options:

A.

Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

B.

Their definition is imported with a reverse-engineering process directly from databases and other sources.

C.

Forevery load the definition of the tables used, their columns and constraints must be manually built.

D.

An external engine must be run to describe what metadata is needed for a Mapping.

Question 8

Which two statements are true about ODI web-based components? (Choose two.)

Options:

A.

ODI Console allows administrators to edit users’ information.

B.

Enterprise Manager Cloud Control provides access to ODI data servers’ settings.

C.

ODI sessions can be monitored in Enterprise Manager Cloud Control.

D.

ODI Console provides access to project and mapping details.

Question 9

How can you define the order in which target data stores are loaded in a Mapping? (Choose the best answer.)

Options:

A.

ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.

B.

You can use the Target Order field.

C.

You can use the Target Load Order field.

D.

You can use the Load Order field.

Question 10

Which two objects can be dragged to a Mapping? (Choose two.)

Options:

A.

Variables

B.

Datastores

C.

Knowledge Modules

D.

Reusable Mappings

Question 11

Identify three capabilities of load plans. (Choose three.)

Options:

A.

restart from failed tasks

B.

exception handling

C.

native support for parallelism

D.

support for Open Tools

E.

restart of an agent

Load More 1z0-448 Questions
Demo: 11 questions
Total 79 questions
Get 1z0-448 Full Access Download 1z0-448 PDF