SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 (C_BODI_20) Free Practice Test

Question 1

Which two rules must you following to deploy a Server Group architecture? (Choose two)

A. All Job servers in a server group must be active for the server group to function

B. Each computer can only contribute one Job server to a server group

C. A maximum of four servers can be added to a server group

D. All the Job servers in the server group must be associated with the same repository

Correct Answer: B,D

Question 2

You are trying to improve the performance of a simple data flow that loads data from a source table into a staging area and only applies some simple remapping using a Query transform. The source database is located on the wan. The network administrator has told you that you can improve performance if you reduce the number or round trips that occur between the data integrator job server and the source database. What can you do in your data flow to achieve this?

A. increase the array reach size parameter in the source table editor

B. Replace the source table with the SQL transform.

C. Increase the commit size in the target table editor.

D. Increase the commit size in the source table editor.

Correct Answer: A

Question 3

Which three methods can you use to create a local variable? (Choose three)

A. Select the Variables tab in the Smart Editor of a custom function

B. Select Tools | Variables | Local Variables in the Data Flow workspace

C. Select Tools | Variables | Local Variables in the Work Flow workspace

D. Select Tools | Variables | Local Variables in the Job workspace

Correct Answer: A,C,D

Question 4

You create a data flow that contains an XML file as the output. The XML file structure contains an element that is used to group other element. This element occurs once in the output XML file. Which method can you use to ensure that this element is populated correctly? For interactive and self-paced preparation of exam DMDI301, try our practice exams. Practice exams also include self assessment and reporting features.

A. Use a row_Generation transform and select one row then map the transform into the from clause of the single element schema.

B. Enter the value"1" in the single element schema mapping.

C. Leave the form clause of the single element schema empty.

D. Place the source table that contains your source rows into the form clause of the single element schema.

Correct Answer: A

Question 5

Where can the XML_Pipeline transform be used within a data flow? (Choose two)

A. Immediately after a Query containing nested data.

B. Immediately after an XML source file.

C. Immediately after an XML template.

D. Immediately after an XML source message.

Correct Answer: B,D

Question 6

Which two tasks can you perform using Data Integrator Designer? (Choose two)

A. Schedule Data Integrator Jobs

B. Launch Data Integrator Jobs

C. Iplort Metadata

D. Create Auto Documentation

Correct Answer: B,C

Question 7

Which three types of group level permissions are available in a Secured Central Object Library? (Choose three)

A. Read

B. Full

C. None

D. Write

E. Hidden

Correct Answer: A,B,C

Question 8

Which two methods can you use to specify multiple files in the same source file format? (Choose two)

A. Create a file list .txt file

B. Use a comma separated list of files

C. Specify a file Lookup table

D. Use wildcards(*.?)

Correct Answer: B,D

Question 9

You create a two stage process for transferring data from a source system to a target data warehouse via a staging area. The job you create runs both processes in an overnight schedule. The job fails at the point of transferring the data from the staging area to the target data warehouse. During the work day you want to return the job without impacting the source system and therefore want to just run the second stage of the process to transfer the data from the staging area to the data warehouse. How would you design this job?

A. Create one data flow which extracts the data form the source system and uses a data_transfer transform to stage the data in the staging area before then continuing to transfer the data to the target data warehouse.

B. Create two data flows the first extracting the data from the source system the second transferring the data to the target data warehouse.

C. Create two data flows the first extracting the data from the source system and uses a data_tranfer transform to write the data to the staging area. The second data flow extracts the data from the staging area and transfers it to the target data warehouse.

D. Create one data flow which extracts from the source system and populates both the staging area and the target data warehouse.

Correct Answer: B

Welcome to TestSimulate

SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 (C_BODI_20) Free Practice Test