Create Next App

Exam contains 79 questions

Page 9 of 14

Question 49 🔥

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

Which database solution meets these requirements?

A. This option is inherited from reverse engineering.

Highly voted

B. This option is always available.

Highly voted

C. You can never make this choice.

Highly voted

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

Highly voted

Discussion of the question

Question 50 🔥

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

Which database solution meets these requirements?

Discussion of the question

Question 51 🔥

You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them? (Choose the best answer.)

Which database solution meets these requirements?

A. on the Coherence Server

Highly voted

B. on the Administration Server

Highly voted

C. on the Node Manager

Highly voted

D. on the Managed Server

Highly voted

Discussion of the question

Question 52 🔥

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step? (Choose the best answer.)

Which database solution meets these requirements?

A. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that uses OdiSendMail to send the email by using the bind variable defined in the first task.

Highly voted

B. Create a Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that uses OdiSendMail to send the email using the bind variable defined in the Command on Source.

Highly voted

C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and an OdiSendMail step.

Highly voted

D. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a

Highly voted

Discussion of the question

Question 53 🔥

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

Which database solution meets these requirements?

A. Their definition is imported with a reverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

Highly voted

B. Their definition is imported with a reverse-engineering process directly from databases and other sources.

Highly voted

C. For every load the definition of the tables used, their columns and constraints must be manually built.

Highly voted

D. An external engine must be run to describe what metadata is needed for a Mapping.

Highly voted

Discussion of the question

Question 54 🔥

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenarios schedule? (Choose the best answer.)

Which database solution meets these requirements?

A. Regenerate the existing scenario.

Highly voted

B. Nothing, the existing scenario will automatically be updated.

Highly voted

C. Generate a new scenario and create a new schedule.

Highly voted

D. Generate a new scenario and attach the previous scenario’s schedule to it.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_448

Exam contains 79 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us