1Z0-448 Online Practice Questions and Answers

How are the ODI repositories upgraded? (Choose the best answer.)

A. by using Opatch

B. by using ODI Studio

C. by using the import/export utilities

D. by using Upgrade Assistant

Which tables created by ODI contain error records? (Choose the best answer.)

A. ERR$

B. ERROR$

C. ODI_ERR$

D. E$

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)

A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.

B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.

C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.

D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

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.

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

A. Openthe model, go to the Journalizing tab, and modify the order there.

B. Right-click Datastore, select Changed Data Capture, and then select Order.

C. Open the model, go to the Journalized tables tab, and modify the order there.

D. Open the data stores, go to the Journalizing tab, and modify the order there.

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.

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

A. This option is inherited from reverse engineering.

B. This option is always available.

C. You can never make this choice.

D. This option may be available only if the underlying technology supports it.

How are the domains of ODI Agents configured? (Choose the best answer.)

A. by using Upgrade Assistant

B. by using ODI Studio

C. by using Domain Creation Assistant

D. by using Configuration Wizard

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