SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 (C-BODI-20) Free Practice Test

Question 1

Where is the data stored for a template table?

A. Underlying database table only during execution

B. Underlying database table during and after execution

C. Job Server memory during Job execution

D. Job Server memory during and after Job execution

Correct Answer: B

Question 2

You want to join the "sales" and "customer" tables. Both tables reside in different data stores. The "sales" table contains approximately five million rows. The "customer" table Contains approximately five thousand rows, the join occurs in memory. How would you set the source table options to maximize the performance of the operation?

A. Set the sales table joins tank to 10 and the cache to "No" then set the customer table join tank to 5 and cache to "yes".

B. Set the sales table joins tank to 5 and the cache to "No" then set the customer table join tank to 10 and cache to "No".

C. Set the sales table joins tank to 5 and the cache to "Yes" then set the customer table join tank to 10 and cache to "No".

D. Set the sales table joins tank to 10 and the cache to "yes" then set the customer table join tank to 5 and cache to "yes".

Correct Answer: A

Question 3

Which three functions can you use in a script? (Choose three)

A. Sysdate

B. Count

C. To_Char

D. Sleep

Correct Answer: A,C,D

Question 4

Which three functions can you perform using the Validation transform? (Choose three)

A. To substitute invalid values with a default value

B. To define a business rule to validate each record and column

C. To check the incoming data for duplicate rows

D. To capture Data Quality statistics that can be viewed on the Data Validation dashboard

Correct Answer: A,B,D

Question 5

In which three objects can you create parameter variables? (Choose three)

A. Data Flow

B. Work Flow

C. Query

D. Job

E. Script

F. Custom functions

Correct Answer: A,B,F

Question 6

Which lookup caching method reduces the number of round trips to the translate table?

A. Pre_Load _Cache

B. No_Cache

C. Demand_Load_Cache

D. Smart_Cache

Correct Answer: A

Question 7

Some of your incoming data are rejected by the database table because of conversion errors and primary key violations. You want to edit and load the failed data rows manually using the SQL Query tool. How can you perform this action?

A. Use the SQL contained in the error log file in the "BusinessObject/data integration/logs..."directory.

B. In the job properties select "trace SQL_Errors" and copy the failed SQL command from the job trace log

C. In the target table editor select "use overflow file", select "write SQL"and enter the filename.

D. In the data flow properties, select "SQL Exception file" and enter the filename.

Correct Answer: C

Question 8

Which lookup function returns multiple columns?

A. Lookup _Adv

B. Lookup

C. Lookup_Ext

D. Lookup_Seq

Correct Answer: C

Question 9

Multiple developers are working on different projects and you want to configure a single
Central Object Library. Which two requirements warrant using a Secured Central Object Library?
(Choose two)

A. Restrict groups of developers from accessing specific objects

B. Restrict groups of developers from deleting specific objects

C. Restrict groups of developers from viewing the history of specific objects

D. Restrict groups of developers from adding specific objects

Correct Answer: A,B

Question 10

Which three applications can you use to schedule Data Integrator batch jobs? (Choose three)

A. BusinessObjects Enterprise Scheduler

B. Data Integrator Scheduler

C. Third party scheduling applications

D. Data Integrator Designer

Correct Answer: A,B,C

Welcome to TestSimulate

SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2 (C-BODI-20) Free Practice Test