1z0-448 Practice Test

1z0-448 Practice Test practice questions, page 3 of 3, with answer review and explanations.

Question 11

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)

  1. Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design.
  2. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
  3. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
  4. Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.

Question 12

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

  1. It enables developers to execute most ODI operations through a Java program.
  2. It can be used to embed ODI processes into another product.
  3. It is used to load data between Teradata and Oracle.
  4. It must be used by ETL developers to develop ODI processes.

Question 13

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)

  1. Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
  2. Add an OdiSendMail step to a knowledge module.
  3. Duplicate the OdiSendMail step into multiple packages.
  4. Create a procedure with a step that uses OdiSendMail and add this procedure into multiple packages.

Question 14

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)

  1. transform only
  2. load and transform
  3. extract and load
  4. extract and transform

Question 15

You 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. Use 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. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
  3. Duplicate the source data store for each Mapping.
  4. Create two distinct subscribers for each Mapping.