[Free] 2018(Jan) Dumps4cert Testking Oracle 1z0-448 Dumps with VCE and PDF 1-10

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-448
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-448.html

Oracle Data Integrator 12cEssentials

Question No: 1

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

  1. high availability

  2. minimal footprint

  3. access to WebLogic connection pools

  4. management in Enterprise Manager Cloud Control

Answer: A,D

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

Question No: 2

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?(Choose the best answer.)

  1. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task.

  2. Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

  3. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep.

  4. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

Answer: B Explanation:

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

Question No: 3

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.

Why did this happen?(Choose the best answer.)

  1. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.

  2. It is not possible to enforce constraints on any technology.

  3. It is only possible to forward-engineer it to the flat file definition.

  4. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.

Answer: D

Explanation: (http://www.oracle.com/technetwork/middleware/data- integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf)

Question No: 4

You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI.

What must you do to accomplish this?(Choose the best answer.)

  1. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.

  2. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.

  3. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.

  4. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.

Answer: B

Question No: 5

Which statement is correct about the tasks that StandaloneAgents perform?(Choose the best answer.)

  1. They update or modify code to be executed, check security, select database servers, and update log files after execution.

  2. They schedule scenarios to be executed, check security, constraints and update log files after execution.

  3. They retrieve code from the execution repository and request database servers, operatingsystems, or scripting engines for execution.

  4. They schedule code from the execution repository and update log files after execution.

Answer: C Explanation:

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12641/overview.htm#ODIGS423)

Question No: 6

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

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

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

  3. Duplicate the source data store for each Mapping.

  4. Create two distinct subscribers for each Mapping.

Answer: A

Explanation: (http://odiexperts.com/changed-data-capture-cdc/)

Question No: 7

You have to loop through a Mapping step three times in a package by using variables. Identify thecorrect variable data type to create the loop. (Choose the best answer.)

  1. numeric

  2. alphanumeric

  3. date

  4. text

Answer: A

Explanation: (https://www.packtpub.com/packtlib/book/Big-Data-and-Business- Intelligence/9781849681742/4/ch04lvl1sec31/Using variables to control loo ps inside packages)

Question No: 8

The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading KnowledgeModule to load the data on the target?(Choose the best answer.)

  1. Only an Integration KnowledgeModule single-technology is required.

  2. Only an Integration Knowledge Module multitechnology is required.

  3. Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single-technology are required.

  4. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

Answer: C Explanation:

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

Question No: 9

Your package logic requires you to retrieve the status of the previous package step into a variable. How must you implement this?(Choose the best answer.)

  1. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  2. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  3. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  4. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Answer: A Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1237)

Question No: 10

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

  1. This works only for Oracle and Informix.

  2. This works only for Oracle and MySQL.

  3. Create a new generic technology to support it.

  4. Use the out-ofthe box Generic SQL technology.

Answer: D Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/projects.htm#ODIDG326)

100% Dumps4cert Free Download!
Download Free Demo:1z0-448 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-448 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No