Oracle 1Z0-448 Online Practice Questions and Exam Preparation

Oracle 1Z0-448 Online Questions & Answers

• Question 1:

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

  ---

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

• Question 2:

  You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

  A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.
  B. Their definition is imported with a reverse-engineering process directly from databases and other sources.
  C. Forevery load the definition of the tables used, their columns and constraints must be manually built.
  D. An external engine must be run to describe what metadata is needed for a Mapping.
  A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

  ---

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/create_rev_model.htm#ODIDG234)

• Question 3:

  What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

  A. Consistent set journalizing runs faster than simple journalizing.
  B. Consistent set journalizing always uses Oracle GoldenGate.
  C. Consistent set journalizing treats each data store individually.
  D. Consistent set journalizing provides a guarantee of consistency of the captured changes.
  D. Consistent set journalizing provides a guarantee of consistency of the captured changes.

  ---

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG272)

• Question 4:

  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.

  ---

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

• Question 5:

  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.
  B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.

  ---

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

• Question 6:

  A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.

  In which database schema must you look to find this table? (Choose the best answer.)

  A. the schema hosting the Work repository
  B. the schema hosting theWork schema of the default schema defined for your source data server
  C. the schema hosting the Staging Area
  D. SYS
  B. the schema hosting theWork schema of the default schema defined for your source data server

  ---

  (http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with- oracle-goldengate/ )

• Question 7:

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

  ---

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

• Question 8:

  Which two statements are true about big data support in ODI? (Choose two.)

  A. ODI uses its own transformation engine to process data in a Hadoop cluster.
  B. ODI performs data transformations inside a Hadoop cluster.
  C. ODI must perform data transformations outside Hadoop in an Oracle database.
  D. ODI allows moving data in and out of a Hadoop cluster.
  B. ODI performs data transformations inside a Hadoop cluster.
  D. ODI allows moving data in and out of a Hadoop cluster.

  ---

  (https://docs.oracle.com/middleware/1213/odi/develop-app- adapters/hadoop.htm#ODIAA193)

• Question 9:

  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.

  ---

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

• Question 10:

  Which two statements are true about ODI web-based components? (Choose two.)

  A. ODI Console allows administrators to edit users' information.
  B. Enterprise Manager Cloud Control provides access to ODI data servers' settings.
  C. ODI sessions can be monitored in Enterprise Manager Cloud Control.
  D. ODI Console provides access to project and mapping details.
  A. ODI Console allows administrators to edit users' information.
  D. ODI Console provides access to project and mapping details.

  ---

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