SAP BODS Online Quiz


Following quiz provides Multiple Choice Questions (MCQs) related to SAP BODS. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Q 1 - Which of the following is used to setup a connection to database in Data Services?

A - Data Store

B - Owner

C - Template table

D - Query transformation

Answer : A


In Data services, data store is used to set up a connection to source and target database.

Q 2 - Which of the following is not a repository type in Data Services architecture?

A - Local

B - Central

C - Shared

D - Profiler

Answer : C


There are three type of repositories in Data Services −

  • Local
  • Central
  • Profiler

Q 3 - Which of the following component of Data services is used to execute real time and batch jobs?

A - Job Server

B - Access Server

C - Management Console

D - Repository

Answer : A

Q 4 - Which of the following is used to create a local repository in Data services?

A - Data Services Server Manager

B - Data Services Workbench

C - Data Services Repository Manager

D - Data Services Locale selector


Answer : C


Create a database Local_Repo and go to Data Services Repository Manager. Configure database as local repository.

Q 5 - Which of the following is used to provide connectivity to other systems such as or the JavaMessagingQueue?

A - Database datastore

B - Application datastore

C - Adapters datastore

D - All of the above

Answer : C

Q 6 - What is the use of adding conditionals to workflow?

A - IF Then Else

B - IF Then

C - For Loop

D - All of the above

Answer : A


You can add Conditionals to workflow. This allows you to implement the If/Else/Then logic on the workflows.

Answer : A


In TDP, Create annotations in form of entities, type, etc. and Input is not changed.

Q 8 - Which of the following recovery mechanism allows you to rerun the jobs without previous partial rerun?

A - Automatic Recovery

B - Manual Recovery

C - Both

D - None

Answer : B


Automatic Recovery − This allows you to run unsuccessful jobs in recovery mode.

Manually Recovery − This allows you to rerun the jobs without considering partial rerun previous time.

Q 9 - As per recommendation for naming conventions, what should be prefix with data store?

A - N/A

B - DF_

C - _DS

D - WF_

Answer : A

Q 10 - Which of the following is default cache type to increase the performance of data transformation occur in memory?

A - In Memory

B - Pageable

C - I/O Disk

D - None of these

Answer : B


Pageable cache is default cache type. It should be used when data flow processes large amount of data that doesn’t fit into memory.