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

Answer : D

Q 2 - Which of the following is responsible for holding user defined objects, metadata and transformation rules in Data services?

A - Datastore

B - Repository

C - Replication Job

D - Engine

E - Adapter

Answer : B


Data Service repository stores all the user defined objects, meta data and transformation rules.

Q 3 - When a variable is used multiple times within a job, it is always suggested to use local variable?

A - True

B - False

Answer : B


When the variable will need to be used multiple times within a job, global variable is used.

Q 4 - Which of the following is used to check access server status and real time services at web application layer?

A - Job Server

B - Access Server

C - Management Console

D - Repository

Answer : C

Q 5 - Which of the following property of data flow can be used to improve the performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons?

A - Degree of parallelism

B - Use Database links

C - Cache Type

D - Execute only once

Answer : C


You can cache data to improve performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons. You can select one of the following values for the Cache type option on your data flow Properties window −

In-memory − Choose this value if your data flow processes a small amount of data that can fit in the available memory.

Pageable − This value is the default.

Q 6 - Which of the following can be used to generate, map, and merge rows from two or more data sources?

A - Platform

B - Text Data Processing

C - None of these

Answer : A

Answer : A


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

Q 8 - To enable recovery in Data Services, when a job fails which of the following option can be used to enable this option?

A - Execution Options

B - Trace

C - Global Variable

D - Substitution parameter

Answer : A

Q 9 - Which of the following returns multiple values based on single or multiple conditions?

A - Lookup()

B - Lookup_ext()

C - Lookup_seq()

D - None of these

Answer : B


lookup() : It returns single value based on single condition.

lookup_ext(): It returns multiple values based on single or multiple condition(s)

Q 10 - Which of the following feature in ETL allows you to create multiple streams from a single stream?

A - Checkpoint

B - Conditional Split

C - Push and Pull

D - Data Profiler

Answer : B