GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Examen ODI

Daniel Carba 20 questions

Take the quiz

Questions in this quiz (20)

  1. 1Identify two benefits that are unique to ODI JEE Agents. (Choose two.)
    1. Ahigh availability
    2. Bminimal footprint
    3. Caccess to WebLogic connection pools
    4. Dmanagement in Enterprise Manager Cloud Control
  2. 2You 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. ACreate 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. BCreate a 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 uses OdiSendMail to send the email using the bind variable defined in the Command on Source.
    3. CCreate 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. DCreate 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.
  3. 3You 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. AIt is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.
    2. BIt is not possible to enforce constraints on any technology.
    3. CIt is only possible to forward-engineer it to the flat file definition.
    4. DIt 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.
  4. 4You 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. AIn the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.
    2. BYou 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. CYou 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. DYou 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.
  5. 5Which statement is correct about the tasks that Standalone Agents perform? (Choose the best answer.)
    1. AThey update or modify code to be executed, check security, select database servers, and update log files after execution
    2. BThey schedule scenarios to be executed, check security, constraints and update log files after execution
    3. CThey retrieve code from the execution repository and request database servers, operating systems, or scripting engines for execution
    4. DThey schedule code from the execution repository and update log files after execution
  6. 6You 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. AUse Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change the JRN_SUBSCRIBER column in the corresponding J$table to keep the changed data present for the second Mapping.
    2. BCreate a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
    3. CDuplicate the source data store for each Mapping.
    4. DCreate two distinct subscribers for each Mapping
  7. 7You have to loop through a Mapping step three times in a package by using variables.
    Identify the correct variable data type to create the loop. (Choose the best answer.)
    1. Anumeric
    2. Balphanumeric
    3. Cdate
    4. Dtext
  8. 8The 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.)
    1. AOnly an Integration KnowledgeModule single-technology is required
    2. BOnly an Integration Knowledge Module multitechnology is required
    3. CA Loading Knowledge Module multitechnology and an Integration Knowledge Module single-technology are required
    4. DBoth a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.
  9. 9Your 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. ACreate a variable, use odiRef.getPrevStepLog () in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package
    2. BCreate 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. CCreate 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. DCreate a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package
  10. 10You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)
    1. AThis works only for Oracle and Informix
    2. BThis works only for Oracle and MySQL
    3. CCreate a new generic technology to support it
    4. DUse the out-of the box Generic SQL technology

Information

Description
Ingeniería Quiz on Examen ODI, created by Daniel Carba on 26/11/2020.
Language
Español
Views
3
Tags
ingeniería
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?