Online Access Free 1z0-448 Exam Questions

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

• A.management in Enterprise Manager Cloud Control
• B.access to WebLogic connection pools
• C.minimal footprint
• D.high availability

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 that stores the same type of data.
• B.Create one Logical Schema per Physical Schema.
• C.Create one Logical Schema per Data Server.
• D.Create one Logical Schema per Context.

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

• A.Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
• B.IfFlow Control is not necessary, an I$ table is not created.
• C.Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
• D.Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this? (Choose the best answer.)

• A.Link the last step of the package to its first step to create an infinite loop.
• B.Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.
• C.Drag the package to the last step in the package, run it asynchronously, and then save.
• D.Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

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 a model to the package, set the Model step to Journalizing Model, 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 sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
• D.Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.