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

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

A. ERR$

B. ERROR$

C. ODI_ERR$

D. E$

You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed.

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

A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.

B. Modifya Knowledge Module to dump the Staging tables' data into log files for review.

C. Use variables in a Package to query the Staging tablesand evaluate the variable values.

D. Reverse engineer the Staging tables in a Modeland review the data contained in it.

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.

How can you accomplish this? (Choose the best answer.)

A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.)

A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.

B. Create a Data Server by using the XML technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

C. Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

D. Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel.

You are designing a load plan in which you must create multiple branches based on the value of a variable.

How do you accomplish this by using Load Plan Editor? (Choose the best answer.)

A. Add a case step and drag the variable into the case step.

B. Create a scenario from the variable and add the scenario to the load plan to create a case step.

C. Add a case step in the load plan and select a variable in the wizard.

D. Drag the variable into the load plan and define a case step.

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

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

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

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

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

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. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

D. Drag the package to the last step in the package, run it asynchronously, and then save.

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

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