Oracle Oracle Certifications 1Z0-448 Questions & Answers

• Question 51:

  Identify two correct statements about reusable Mappings. (Choose two.)

  A. They can have generic input and output signatures.

  B. They contain both a Logical and Physical Mapping design.

  C. They can be used within regular Mappings.

  D. They can be executed directly.

  E. They can be shared across projects.

  Correct Answer: AB

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

• Question 52:

  In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation? (Choose the best answer)

  A. It is not possible to use a specific partition.

  B. Only ODI variables can be used to filter the target table loading.

  C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

  D. An option in the Mapping can be used to declare the partition that has to be used for the loading.

  Correct Answer: D

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

• Question 53:

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

  A. Oracle BPEL Process Manager

  B. Oracle GoldenGate

  C. ODI Console

  D. Oracle WebLogic Server

  Correct Answer: C

  (http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi- architecture-1129425.pdf)

• Question 54:

  Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

  A. Oracle GoldenGate primarily performs aggregations for ODI.

  B. Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

  C. Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

  D. ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

  E. ODI and Oracle GoldenGate enable real-time business intelligence.

  Correct Answer: AE

  (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate- realtime-access2031152.pdf)

• Question 55:

  You are working on notifications in a package and you must send an email containing an error message in case a Package step fails.

  Which odiRef method do you use to access the error message? (Choose the best answer.)

  A. odiRef.getSession()

  B. odiRef.getInfo()

  C. odiRef.getPrevStepLog()

  D. odiRef.getStep()

  Correct Answer: B

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

• Question 56:

  Which is the correct statement about the contents of Master repositories? (Choose the best answer.)

  A. They contain data model and security information.

  B. They contain security and topology information.

  C. They contain project and topology information.

  D. They contain project and security information.

  Correct Answer: B

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

• Question 57:

  You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment.

  Which statement is true? (Choose the best answer.)

  A. The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.

  B. Only the production environment can be used.

  C. All environments linked to a logical schema can be used to reverse-engineer table structures.

  D. Only a Java engine intermediate environment can be processed.

  Correct Answer: C

  (http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODIDG227)

• Question 58:

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

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

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

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

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

  Correct Answer: A

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

• Question 59:

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

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

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

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

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

  Correct Answer: C

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

• Question 60:

  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.

  Correct Answer: A

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