Oracle 1Z0-448 Online Practice Questions and Exam Preparation

Oracle 1Z0-448 Online Questions & Answers

• Question 1:

  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
  A. ODI Console

• Question 2:

  You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

  A. Right-click the step in Package Editor and select the No Logging menu item.
  B. Modify Operator Navigator settings to disable that step from being displayed.
  C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.
  D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.
  C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

• Question 3:

  Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

  A. It is possible to set the execution location on source, staging area, or target.
  B. All transformations are executed on the staging area.
  C. Only the source and target servers can be used to execute expressions.
  D. All expressions are executed on the source area.
  A. It is possible to set the execution location on source, staging area, or target.

  ---

  explanation:

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

• Question 4:

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

  A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.
  B. The Knowledge Module must be customized only for aggregation functions.
  C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.
  D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.
  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 5:

  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.
  D. Use the out-ofthe box Generic SQL technology.

  ---

  explanation:

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

• Question 6:

  Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

  A. Evaluate Variable
  B. Set Variable
  C. Declare Variable
  D. Refresh Variable
  B. Set Variable

• Question 7:

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

  A. ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.
  B. You can use the Target Order field.
  C. You can use the Target Load Order field.
  D. You can use the Load Order field.
  C. You can use the Target Load Order field.

  ---

  explanation:

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

• Question 8:

  You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "P1." How must you proceed? (Choose the best answer.)

  A. Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally setView privilegesto Active for the Mapping objects.
  B. Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Mapping objects.
  C. Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
  D. Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
  D. Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.

  ---

  explanation:

  (https://docs.oracle.com/cd/B12037_01/network.101/b10777/protdata.htm#1006312)

• Question 9:

  How do you provide a timeout value for an exception step? (Choose the best answer.)

  A. by using a custom Groovy script
  B. by using a variable
  C. by using the Timeout filed
  D. by using a Timeout knowledge module
  B. by using a variable

  ---

  explanation:

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#CHDGFEGJ)

• Question 10:

  Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

  A. OdiOutFile
  B. OdiFileCopy
  C. OdiFileMove
  D. OdiInFile
  A. OdiOutFile

  ---

  explanation:

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG875)