1Z0-448 Online Practice Questions and Answers

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

A. It enables developers to execute most ODI operations through a Java program.

B. It can be used to embed ODI processes into another product.

C. It is used to load data between Teradata and Oracle.

D. It must be used by ETL developers to develop ODI processes.

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

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

B. Add anOdiSendMailstep to a knowledge module.

C. Duplicate theOdiSendMail stepinto multiple packages.

D. Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages.

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

A. transform only

B. load and transform

C. extract and load

D. extract and transform

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

A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

C. Duplicate the source data store for each Mapping.

D. Create two distinct subscribers for each Mapping.

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.

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.

How can you accomplish this? (Choose the best answer.)

A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.

Identify two correct Restart values for parallel steps in load plans. (Choose two.)

A. Restart from new session.

B. Restart from failure.

C. Restart from failed children.

D. Restart all children.

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.

You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas? (Choose the best answer.)

A. Create one Logical Schema per Physical Schema.

B. Create one Logical Schema per Physical Schema that stores the same type of data.

C. Create one Logical Schema per Data Server.

D. Create one Logical Schema per Context.

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