VCEdump

1Z0-448 Oracle Data Integrator 12c Essentials

PDF question preview Back to product

Reading controls

Reader tools

Free demo

12 of 79 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice11

Multiple choice1

Oracle · 1Z0-448

Free 1Z0-448 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Multiple choice

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

Reveal answer details Close answer details

Correct answersA, B, C

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1352)
This link says

"restartability" as one of options, so it can be either A or E, most likely its A

Question 2

Single choice

You are a project developer using ODI and want to consolidate your own local metadata repositories.

Identify the true statement. (Choose the best answer.)

A
You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.
B
You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.
C
You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.
D
You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

Reveal answer details Close answer details

Correct answerD

Question 3

Single choice

The source and target data stores are located on the same data server.

Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Choose the best answer.)

A
Only an Integration KnowledgeModule single-technology is required.
B
Only an Integration Knowledge Module multitechnology is required.
C
Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single-technology are required.
D
Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

Reveal answer details Close answer details

Correct answerC

Explanation

(
http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1059)

Question 4

Single choice

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

A
Data transformation must be distributed across several scalable nodes.
B
It is mandatory to have an intermediate server.
C
It is better to load data directly from sources into a data warehouse server.
D
It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

Reveal answer details Close answer details

Correct answerC

Question 5

Single choice

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

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.

Reveal answer details Close answer details

Correct answerD

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIDG/admin_reps.htm#ODIDG155)

Question 6

Single choice

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects.

How must you implement this? (Choose the best answer.)

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.

Reveal answer details Close answer details

Correct answerD

Explanation

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

Question 7

Single choice

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

A
ERR$
B
ERROR$
C
ODI_ERR$
D
E$

Reveal answer details Close answer details

Correct answerD

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)

Question 8

Single choice

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.

Reveal answer details Close answer details

Correct answerA

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIDG/debugging.htm#ODIDG1641)

Question 9

Single choice

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

A
ODI Console
B
Oracle GoldenGate
C
Oracle WebLogic Server
D
Oracle BPEL Process Manager

Reveal answer details Close answer details

Correct answerA

Question 10

Single choice

You need to create a package that automatically sends an alert to users in case the third step fails.

Which option represents the steps to accomplish this? (Choose the best answer.)

A
Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow.
B
Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.
C
Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow.
D
Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow.

Reveal answer details Close answer details

Correct answerB

Explanation

(
https://gurcanorhan.wordpress.com/2012/11/30/odi-alert-mechanism/)

Question 11

Single choice

You must split a model with many database tables into multiple sub-models based on their names.

How must you proceed? (Choose the best answer)

A
Create new submodels and drag data stores individually to each submodel.
B
Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their names.
C
Create new submodels and leverage the automatic distribution feature at the submodels level to automatically move the data stores based on their names.
D
Create new models, drag the data stores individually to each model and then drag the models to the parent model to create submodels.

Reveal answer details Close answer details

Correct answerB

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIDG/organizing_documenting.htm#ODIDG524)

Question 12

Single choice

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

Reveal answer details Close answer details

Correct answerA

Explanation

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

Free 1Z0-448 Exam Dumps Preview

Oracle Data Integrator 12c Essentials

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

VOL	TYPE	QUESTIONS
1	Single choice	11
2	Multiple choice	1