1Z0-448 Online Practice Questions and Answers

You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment.

Which statement is true? (Choose the best answer.)

A. The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.

B. Only the production environment can be used.

C. All environments linked to a logical schema can be used to reverse-engineer table structures.

D. Only a Java engine intermediate environment can be processed.

Which product is included in ODI web-based components? (Choose the best answer.)

A. Oracle BPEL Process Manager

B. Oracle GoldenGate

C. ODI Console

D. Oracle WebLogic Server

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 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()

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.

The source and target data stores are located on the same data server.

Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Choose the best answer.)

A. Only an Integration KnowledgeModule single-technology is required.

B. Only an Integration Knowledge Module multitechnology is required.

C. Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single- technology are required.

D. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

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.)

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 usesOdiSendMailto send the email by using the bind variable defined in the first task.

B. Createa 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 usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

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 anOdiSendMailstep.

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 Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

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.

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