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 used to contain object definition in Data services?

A - Reusable Objects

B - Repository

C - Object Library

D - Engine

Answer : C


An object library is used to contain object definition and when an object is dragged and dropped from library, a new reference to an existing object is created.

Q 3 - Which of the following repository is used to control version management of objects and is used for multiuser development?

A - Local

B - Central

C - Profiler

D - Shared

Answer : B


Central Repository − It is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object. Hence, it allows you to move to previous versions.

Q 4 - When you create a local repository in Data Services, which of the following can be used to configure the repository?

A - Repository Manager


C - Server Manager

D - Workbench

Answer : B


Central Management Console (CMC) in SAP BI Platform is used for configuring a new repository.

Q 5 - In a Data flow to extract or load the data directly, which of the following method can be used for XML file?

A - Direct

B - Through Adapter

C - Both

D - None of these

Answer : A

Q 6 - Workflows can be created using the following methods −

Object Library

Tool Palette

A - True

B - False

Answer : A

Q 7 - Which of the following is a type of embedded data flow?

A - One Input

B - One Output

C - No input or output

D - All of the above

Answer : D


The following types of embedded data flows can be used −

One Input − Embedded data flow is added at the end of dataflow.

One Output − Embedded data flow is added at the beginning of a data flow.

No input or output − Replicate an existing data flow.

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 tool is used for scheduling and to view error logs for replication job?

A - Designer

B - Management Console

C - Repository Manager

D - Workbench

Answer : B


Q 10 - Which of the following option allows you to perform optimization in Data Services?

A - Data Cleansing

B - Data Integration

C - Optimized SQL

D - Validate

Answer : C