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

Oracle 1z0-448 - Oracle Data Integrator 12cEssentials

Oracle 1z0-448 Premium Access     Download Demo    
Page: 2 / 3
Total 79 questions

What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

A.

Consistent set journalizing runs faster than simple journalizing.

B.

Consistent set journalizing always uses Oracle GoldenGate.

C.

Consistent set journalizing treats each data store individually.

D.

Consistent set journalizing provides a guarantee of consistency of the captured changes.

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

A.

ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

B.

It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

C.

It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

D.

It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.

How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

A.

UseOdiPingAgentin a package to ping AGT agent.

B.

In Topology, test the connections to servers A and B by using the AGT agent.

C.

In Topology, test the connections to the AGT agent.

D.

In Topology, test the connections to servers A and B by using Local (No Agent).

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

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.

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

A.

conditions

B.

foreign keys

C.

primary keys

D.

alternate keys

E.

not null

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

A.

This works only for Oracle and Informix.

B.

This works only for Oracle and MySQL.

C.

Create a new generic technology to support it.

D.

Use the out-ofthe box Generic SQL technology.

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

A.

Use a dedicated schema such asODI_STAGING.

B.

UseTEMP.

C.

Use the same schema as the Data Schema.

D.

Use SYSTEM.

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)

A.

It is only possible to see code at the Session level.

B.

It is only possible to view code at the Task level.

C.

Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.

D.

All generated code can be viewed together at the step level, with a complete list of executed code.

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

A.

extracting source data to flat files

B.

triggers

C.

Oracle GoldenGate

D.

before-and-after database image comparison

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

A.

restart from failed tasks

B.

exception handling

C.

native support for parallelism

D.

support for Open Tools

E.

restart of an agent