SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 - C-BODI-20 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two options must you set to capture your audit information to the Trace Logs? (Choose two)

A. Select Tools I Options I Designer I General I Capture Audit Data B. Select "Enable Auditing" in the Job parameters. C. Select "Edit Job Server Config" I "Enable Auditing" in the Server Manager D. Set Trace Audit Data to "Yes"

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

You are executing a Job in Recovery mode and the Job fails having partially loaded the Target Table. You rerun the Job by selecting "Recover from last failed execution"

A. The objects completed prior to and including the failed Data Flow are re-run in Auto-correct mode B. The objects completed prior to the failed Data Flow are skipped and the failed Data Flow is rerun from the beginning C. The transaction is rolled back and the Job re-executes from the beginning D. The objects completed prior to the failed Data Flow are skipped and the failed Data Flow continues from the point of failure

Discussion 0

Correct Answer: B Vote an answer

Question 3

Which two interfaces requires an adapter data store? (Choose two).

A. Web service B. Sap R/3 C. COBOL copybook D. MQ series

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

Your table contains the "sales_date" and "sales-time" fields both fields are data type archer (20). The "sales_date" format is 21-jan- 1980'. The "sales_time" format is '18-30-12'. You need to combine both fields and load the results into a single Target field of the data time data type. Which expression must you use to perform the conversion?

A. to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss') B. to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss') C. to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss') D. to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which three combinations of input and output schemas are permitted in on embedded data flow? (Choose three)

A. 0 input and 1 outputs B. Multiple input and multiple outputs C. 1 input and 1 outputs D. 1 input and 0 outputs E. 1 input and multiple outputs

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 6

You are working in a multi-user central repository based environment. You select "Rename owner" on an object which is not checked out. The object has one or more dependent objects in the local repository. What is the outcome?

A. Data Integrator renames the owner of all 0bjects within the selected data store. B. Data Integrator renames the individual object owner. C. Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified. D. Data Integrator displays the "This object is checked out from central repository "X". Please select Tools Central Repository. to activate that repository before renaming Message.

Discussion 0

Correct Answer: C Vote an answer

Question 7

Where do imported stored procedures appear in the Local Object Library?

A. Datastore Functions B. Custom Functions C. Built-in Functions D. External Functions

Discussion 0

Correct Answer: A Vote an answer

Question 8

Which SQL statement displays when the "Trace SQL Readers" option is set to "Yes"?

A. SQL from the Table_Comparison transform B. SQL from the Lookup_ext function C. SQL to the target tables D. SQL from the source tables

Discussion 0

Correct Answer: D Vote an answer

Question 9

You have declared a local variable in a Work Flow. Which three objects in the Work Flow can use the variable? (Choose three)

A. Conditional B. While C. Work Flow D. Data Flow E. Script

Discussion 0

Correct Answer: A,B,E Vote an answer