Free Practice Questions for Oracle 1Z0-448 Exam

Question 1

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

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

BYou can use the Target Order field.

CYou can use the Target Load Order field.

DYou can use the Load Order field.

Correct Answer: C. You can use the Target Load Order field.

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1562)

Question 2

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

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

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

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

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

Correct Answer: D. Select the Use Unique Temporary Object Names check box at the Physical Design level.

Explanation:

(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

Question 3

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

AUseOdiPingAgentin a package to ping AGT agent.

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

CIn Topology, test the connections to the AGT agent.

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

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

Explanation:

(http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi-connectivityissues/) as per this link even choice A is right as its alternative/additional method for testing connectivity

Question 4

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

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

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

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

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

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

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG287)

Question 5

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

AodiMasterRepository

BMasterRepository

Codimasterrepository

DODIMasterRepository

Correct Answer: A. odiMasterRepository

Explanation:

(https://docs.oracle.com/cd/E23943_01/install.1111/e16453/configure.htm#ODING303)

Question 6

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

AThe Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

BThe Knowledge Module must be customized only for aggregation functions.

CThe Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

DThe Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Correct Answer: D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1625)

Question 7

Which product is included in ODI web-based components? (Choose the best answer.)

AOracle BPEL Process Manager

BOracle GoldenGate

CODI Console

DOracle WebLogic Server

Correct Answer: C. ODI Console

Explanation:

(http://www.oracle.com/technetwork/middleware/data-integrator/overview/oraclediarchitecture-1-129425.pdf)

Question 8

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)

Ahigh availability

Bminimal footprint

Caccess to WebLogic connection pools

Dmanagement in Enterprise Manager Cloud Control

Correct Answer: A. high availability; D. management in Enterprise Manager Cloud Control

Explanation:

(http://www.ateam-oracle.com/odi-agents-standalone-jee-and-colocated/)

Question 9

You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this? (Choose the best answer.)

AYou need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.

BYou must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.

CYou need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.

DYou must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.

Correct Answer: A. You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG149)

Question 10

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control. Which is the correct command to start this agent on Linux? (Choose the best answer.)

A./agent.sh --NAME=OracleDIAgent1 --PORT=20910

B./agent.sh --NAME=OracleDIAgent1

C./startComponent.sh OracleDIAgent1

D./startComponent.sh OracleDIAgent1 --PORT=20910

Correct Answer: A. ./agent.sh --NAME=OracleDIAgent1 --PORT=20910

Explanation:

(https://community.oracle.com/thread/3780742?start=0&tstart=0)