1Z0-448 Online Practice Questions and Answers

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

A. extracting source data to flat files

B. triggers

C. Oracle GoldenGate

D. before-and-after database image comparison

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

A. Use a dedicated schema such asODI_STAGING.

B. UseTEMP.

C. Use the same schema as the Data Schema.

D. Use SYSTEM.

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.

You are working on notifications in a package and you must send an email containing an error message in case a Package step fails.

Which odiRef method do you use to access the error message? (Choose the best answer.)

A. odiRef.getSession()

B. odiRef.getInfo()

C. odiRef.getPrevStepLog()

D. odiRef.getStep()

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.

Which are the two correct statements about Work repositories? (Choose two.)

A. They contain project and security information.

B. They contain data models and execution information.

C. They contain data and security information.

D. They contain data models and project information.

Which two statements are true about ODI web-based components? (Choose two.)

A. ODI Console allows administrators to edit users' information.

B. Enterprise Manager Cloud Control provides access to ODI data servers' settings.

C. ODI sessions can be monitored in Enterprise Manager Cloud Control.

D. ODI Console provides access to project and mapping details.

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.

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

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

A. Right-click the step in Package Editor and select the No Logging menu item.

B. Modify Operator Navigator settings to disable that step from being displayed.

C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.