Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Oracle Data Integrator 12cEssentials Question and Answers

Oracle Data Integrator 12cEssentials

Last Update May 6, 2024
Total Questions : 79

We are offering FREE 1z0-448 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-448 free exam questions and then go for complete pool of Oracle Data Integrator 12cEssentials test questions that will help you more.

1z0-448 pdf

1z0-448 PDF

$35  $99.99
 Add to Cart
1z0-448 Engine

1z0-448 Testing Engine

$42  $119.99
 Add to Cart
1z0-448 PDF + Engine

1z0-448 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

Options:

A.  

extracting source data to flat files

B.  

triggers

C.  

Oracle GoldenGate

D.  

before-and-after database image comparison

Discussion 0
Questions 2

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)

Options:

A.  

Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.

B.  

Use variables in the Logical Design of the Mapping to create unique temporary object names.

C.  

Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.

D.  

Select the Use Unique Temporary Object Names check box at the Physical Design level.

Discussion 0
Questions 3

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.

Discussion 0
Questions 4

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario’s schedule? (Choose the best answer.)

Options:

A.  

Regenerate the existing scenario.

B.  

Nothing, the existing scenario will automaticallybe updated.

C.  

Generate a new scenario and create a new schedule.

D.  

Generate a new scenario and attach the previous scenario’s schedule to it.

Discussion 0
Questions 5

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

Options:

A.  

Openthe model, go to the Journalizing tab, and modify the order there.

B.  

Right-click Datastore, select Changed Data Capture, and then select Order.

C.  

Open the model, go to the Journalized tables tab, and modify the order there.

D.  

Open the data stores, go to the Journalizing tab, and modify the order there.

Discussion 0
Questions 6

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)

Options:

A.  

transform only

B.  

load and transform

C.  

extract and load

D.  

extract and transform

Discussion 0
Questions 7

Which tables created by ODI contain error records? (Choose the best answer.)

Options:

A.  

ERR$

B.  

ERROR$

C.  

ODI_ERR$

D.  

E$

Discussion 0
Questions 8

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

Options:

A.  

Right-click the step in Package Editor and select the No Logging menu item.

B.  

Modify Operator Navigator settings to disable that step from being displayed.

C.  

In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

D.  

Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.

Discussion 0
Questions 9

Which are the two correct statements about Work repositories? (Choose two.)

Options:

A.  

They contain project and security information.

B.  

They contain data models and execution information.

C.  

They contain data and security information.

D.  

They contain data models and project information.

Discussion 0
Questions 10

How do you provide a timeout value for an exception step? (Choose the best answer.)

Options:

A.  

by using a custom Groovy script

B.  

by using a variable

C.  

by using the Timeout filed

D.  

by using a Timeout knowledge module

Discussion 0
Questions 11

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

Options:

A.  

Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

B.  

Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

C.  

Duplicate the source data store for each Mapping.

D.  

Create two distinct subscribers for each Mapping.

Discussion 0
1z0-448 Questions Answers | 1z0-448 Test Prep | Oracle Data Integrator 12cEssentials Questions PDF | 1z0-448 Online Exam | 1z0-448 Practice Test | 1z0-448 PDF | 1z0-448 Test Questions | 1z0-448 Study Material | 1z0-448 Exam Preparation | 1z0-448 Valid Dumps | 1z0-448 Real Questions | Oracle Data Integrator 12c Certified Implementation Spe 1z0-448 Exam Questions