Oracle Oracle Certifications 1Z0-448 Questions & Answers

• Question 11:

  Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)

  A. ODI Runtime Agent

  B. ODI Standalone Agent

  C. ODI JEE Agent

  D. ODI Colocated Standalone Agent

  Correct Answer: C

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

• Question 12:

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

  A. numeric

  B. alphanumeric

  C. date

  D. text

  Correct Answer: A

  (https://www.packtpub.com/packtlib/book/Big-Data-and-Business- Intelligence/9781849681742/4/ ch04lvl1sec31/Using%20variables%20to%20control%20loops%20i nside%20packages)

• Question 13:

  The workflow you are designing requires checking to see whether there are records available in a source table before doing anything.

  Which ODI tool must you use to implement this? (Choose the best answer.)

  A. OdiWaitForData

  B. OdiWaitForCDCData

  C. OdiWaitForLogData

  D. OdiWaitForTable

  Correct Answer: A

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

• Question 14:

  Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

  A. Data transformation must be distributed across several scalable nodes.

  B. It is mandatory to have an intermediate server.

  C. It is better to load data directly from sources into a data warehouse server.

  D. It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

  Correct Answer: C

• Question 15:

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

  A. high availability

  B. minimal footprint

  C. access to WebLogic connection pools

  D. management in Enterprise Manager Cloud Control

  Correct Answer: AD

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

• Question 16:

  Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

  A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.

  B. IfFlow Control is not necessary, an I$ table is not created.

  C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

  D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

  Correct Answer: D

  (http://www.oracle.com/us/products/middleware/data-integration/odi-performance- guide-wp-2147067.pdf)

• Question 17:

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

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

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

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

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

  Correct Answer: B

• Question 18:

  You design a package with mappings that consume data from journalized data stores in Consistent Set CDC mode.

  Which option represents the steps that must be performed at the beginning of your package to accomplish this? (Choose the best answer.)

  A. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.

  B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.

  C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.

  D. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.

  Correct Answer: C

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

• Question 19:

  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

  Correct Answer: B

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

• Question 20:

  You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.

  How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

  A. UseOdiPingAgentin a package to ping AGT agent.

  B. In Topology, test the connections to servers A and B by using the AGT agent.

  C. In Topology, test the connections to the AGT agent.

  D. In Topology, test the connections to servers A and B by using Local (No Agent).

  Correct Answer: B

  (http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi-connectivity- issues/) as per this link even choice A is right as its alternative/additional method for testing connectivity