1Z0-448 Online Practice Questions and Answers

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic.

How should you proceed? (Choose the best answer.)

A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.

B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.

C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

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$

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

A. Oracle GoldenGate primarily performs aggregations for ODI.

B. Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

C. Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

D. ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

E. ODI and Oracle GoldenGate enable real-time business intelligence.

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control.

Which is the correct command to start this agent on Linux? (Choose the best answer.)

A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910

B. ./agent.sh –NAME=OracleDIAgent1

C. ./startComponent.sh OracleDIAgent1

D. ./startComponent.sh OracleDIAgent1 –PORT=20910

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 scenario's schedule? (Choose the best answer.)

A. Regenerate the existing scenario.

B. Nothing, the existing scenario will automaticallybe updated.

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

D. Generate a new scenario and attach the previous scenario's schedule to 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

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything.

Which ODI tool must you use to implement this? (Choose the best answer.)

A. OdiWaitForData

B. OdiWaitForCDCData

C. OdiWaitForLogData

D. OdiWaitForTable

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

A. OdiOutFile

B. OdiFileCopy

C. OdiFileMove

D. OdiInFile

How do you provide a timeout value for an exception step? (Choose the best answer.)

A. by using a custom Groovy script

B. by using a variable

C. by using the Timeout filed

D. by using a Timeout knowledge module